Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
here's an idea for you, create a fild in the script with the right(%CATEGORY,2) and do the setanalysis on that.