create a percentage range with variable

[Paula1]

variable:

vrange = num ((sum (value1) / (sum (value2))) - 1, '#. ## 0,00%)

the range below does not work in a filter. what to do

= if ($ (vrange)> '0,0' e $ (vrange) <'0,10', '01 - range de 0 á 10% ',
if ($ (vrange)>' 0,1099 'e $ (vrange) <'0,20', '02 - range de 11 á 20% ',
if ($ (vrange)>' 0,2099 'e $ (vrange) <' 0,30 ', '03 - range de 21 á 30% ',
if ($ (vrange)>' 0,3099 'e $ (vrange) <' 0,40 ', '04 - range de 31 á 40%',
if ($ (vrange)> '0 , 4099 'e $ (vrange) <' 0,50 ', '05 - range de 41 á 50%',
se ($ (vrange)> '0,5099' e $ (vrange) <'0,60', '06 - range de 51 á 60% '))))))))))

Table1:
LOAD * INLINE [

code,  value2
1 1, 45,32
2, 47,85
3, 43,17
4, 42,11
5, 18,45
6, 10,85
];

tABLE2:
LOAD * INLINE [

code,
value2
2 1, 17,82 2, 31,45
3, 17,32
4, 12,14
5, 19,45
6, 7,25
];

[MarcoWedel · Accepted solution]

=Aggr(If($(vrange) > 0.0    and $(vrange) < 0.10, '01 - range de 0 á 10%',
      If($(vrange) > 0.1099 and $(vrange) < 0.20, '02 - range de 11 á 20%',
      If($(vrange) > 0.2099 and $(vrange) < 0.30, '03 - range de 21 á 30%',
      If($(vrange) > 0.3099 and $(vrange) < 0.40, '04 - range de 31 á 40%',
      If($(vrange) > 0.4099 and $(vrange) < 0.50, '05 - range de 41 á 50%',
      If($(vrange) > 0.5099 and $(vrange) < 0.60, '06 - range de 51 á 60%')))))),code)

Num(Sum(value1)/Sum(value2) - 1, '#.##0,00%')

hope this helps

Marco

[Paula1]

😁😀

thanks