Less than 80 % and less than 20 %

[beck_bakytbek]

Hi Folks,

i got a question: my table does look like:

Product	in %
A	0.75
B	0.65
C	0.18
D	0.15
E	0.04
F	0.04

my expected output is:

Product	in %	Comments
A	0.75	less than 80 %
B	0.65	less than 80 %
C	0.18	less than 20 %
D	0.15	less than 20 %
E	0.04	less than 5 %
F	0.04	less than 5 %

when i create the expression: if then so i got only column with: less than 80 %, how can i create dynamicly expression to create the comments like: less than 80 %, less than 20 % and less than 5%. Should i create with function class () the intervall and then use function intervallmatch?

Does anybody have another idea how to resolve this issue?

Thanks a lot

Bek

[Or · Accepted solution]

If this is your particular case, it's likely easiest to solve with a handful of if() statements:

If([in %]<0.05,'less than 5 %', if([in %]<0.2, 'less than 20 %', if([in %] < 0.8,'less than 80 %')))

[beck_bakytbek]

oh man, you just had to adjust the order   =).  thanks a lot for your time and help @Or