Interval set analysis

[jaymerry]

Hello,

Do you know if it's possible to make an interval with a set analysis ?

I'm trying to find the values contains between the last two char of CATEGORY => 11 and the last two char of CATEGORY <=16 (I have the function right() ) :

example of CATEGORY's data :

99-12

98-14

97-09

I have tried :

=sum({<%CATEGORY={"=RIGHT(%CATEGORY,2)>=11,RIGHT(%CATEGORY,2)<=16"}>}[Qty])

or

=sum({<%CATEGORY={"=RIGHT(%CATEGORY,2)>=11"},%CATEGORY={"=RIGHT(%CATEGORY,2)<=16"}>}[Qty])

But it doesn't work..

Have you any idea ?

Thanks for your help,

Best regards,

Jaymerry

[danielrozental]

here's an idea for you, create a fild in the script with the right(%CATEGORY,2) and do the setanalysis on that.