Rounding of percentage value

[#1]

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

[Anonymous]

Probably?

I would think its the accumulation because the rounding occurs before the accumulation which results in +/- integer

[Anonymous · Accepted solution]

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.

[#4]

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

[#5]

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

[#6]

I will have a try on this as well