Hi,
how to solve the problem I have crostab table and two different data item,(invoiced,measured) and both will be the same data only a small difference is in the decimal in (measured), such as 200202 | 200202.89 , in this situation i want report show only invoiced 200202 and ignore 200202.89.
any idea?
Can u tell the Question Clearly...???
Want you Ignore measure or what...????
In place of values mention Data Items..it will give clear
Thus for example, the measured energy charged 7512.2 and 7512 are equally large, in which case said. place of use of the list, should not be at all. Similarly, the calculation of percentages should be made on the basis of the rounding-off.
That's rounding thing would be critical. If it is put in place, so this could even export production, as long as one is a special case tested (expired and a new contract at the same time the place of use).
Hi,
1. Just you remove the Measured kWh Data Item
2. Unlock the Report
3. Click on Invoiced kWh (not entire cell)
4. Cut/Remove the Text Invoiced kWh
5. Drag the Table with 2 columns and 1 row drop it into Invoiced kWh CELL
6. First table cell paste Invoices kWh and Second cell, Drag a Text item Drop it and give name as Measured kWh
7. Lock the report.
8. here you can see Single value for two data items....
That value is Invoiced kWh