Hi,
I'm trying to round off a decimal value to a whole value using the function ROUND or CEILING.
The problem i'm facing here is while i run the tabular data, it works perfect where as when i run the report the function is not working.
For example: If the average value is 6.75, the below expression in the tabular data returns 7. Where as when generating report it returns 6.
round(average([Data Item] for report),0).
Is there a way to resolve? You help is much appreciated.
Rounding sucks. Does it round down when you use CEILING as well?