Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a senario where i have to round the values
the data is as below
country value output
a 12.56 % 13 %
b 10.2 % 10 %
if the value after the point is >= 5 then it should make it as 13
if the value after the point is < 5 then it should make it as 10
Regards
Probably?
I would think its the accumulation because the rounding occurs before the accumulation which results in +/- integer
You know what you could do is just forget the rounding function and use the integer format in the number tab. That will do the rounding AFTER the accumulation.
Hi Aron thanks a ton, it worked thank you so much
=round(sum({<IsSameMonth={'1'}>}TOT)/sum({<IsSameMonth={'1'}>}total(TOT)) * 100, 0.01)
i used the above expression and set the number format to integer
thank you so much
can you please help me out in this
largest 5 values in staright table
Top two values in current month comparing the same values with previous month
I will have a try on this as well