I think / I hope I'm missing something very obvious here ;)
We have a 'cross-tabbed' report. We have calculations in the main table data that gives data measured in multiples of 0.25 (hrs) per row.
When the cross-tabbed reports adds it up (SUM aggregation) it seems it can only cope with one decimal place and so it rounds up.
It appears that 0.25 is treated as 0.3 and 0.75 is treated as 0.8.
And, of course, when these individual figures are totalled, the rounding up is compounded which skews the data further.
Please tell me how to get two decimal places working in cross-tabbed results so that:
0.25 is treated as 0.25 and not 0.3, and
0.75 is treated as 0.75 and not 0.8, and therefore
0.25 + 0.75 will return a value of 1.0 and not 1.1
Thank you! :)
Please sign in to leave a comment.