Hi
I am crying to create a set with the condition that the customers with sales that lie between 1e6 and 5e6. How can I create this? I started by selecting the condition that has the symbol <> but then how to enter the data for this condition? Should the two numbers that are required to specify the lower and upper limits be separated by comma or what? I could not find anything in the documentation.
Thanks,
Bhushan
2 answers
You could do something like this:
To enter another range for categorizing, use ELSEIF in the same statement above. Or to change null to text, you could say:
If sum([Sales]) > 500 and sum([Sales]) < 1000 then 'Bad Sale' ELSE 'Good Sale' END
