Special rounding percentages

[AlbertNP90]

How can I define this logic in a QlikSense pivot table? 

Percentages special rounding
Basically, values are rounded to match 100%.

1. All values are rounded down.
2. Identify how much percentage points are missing to match 100% in total.
   E.g.: if the down rounded values are 97%, then 3 points have to be distributed.
3. The percentages with the biggest decimal part (value after the comma) get the extra points.

E.g.:

       Satisfied: 26.98%,

       Fairly satisfied: 24.78%,

       Not very satisfied: 25.7%,

       Not at all satisfied: 22.54%

           26 + 24 + 25 + 22 = 97 -> 3 extra points. To be assigned to the 3 percentages with higher decimal part:
           27 + 25 + 26 + 22 = 100

Thank you very much

[brunobertels]

Hi 

I assume you have somethink like this : 

then the trick here is to rank the value then if rank = 4 use floor() function if not then use round  () function like this 

if(aggr(rank(total result), type)='4',floor(sum(result),'0,01'),round(sum(result),'0,01'))

see below table : 

hope it helps