Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a Dashboard which shows how many 'Days of Sales' a customer has outstanding at the moment.
Values range from everywhere between 0 and 400.
I'm trying to create an easier way to select all values below or above a certain value (or between two values).
So I have a list box with all the values (1, 2, 3, 4, 5, etc. etc. 300, 301, 310, etc. etc.).
Now I want to create groups, let's say <10, >10<50, >50<100,>100.
Is there a way to do this? I have been searching for a solution, but can't find one...
Thanks in advance!
Kind regards,
Stefan.
Create a list for the expression
=If([Days of Sales]<10,'<10',If([Days of Sales]<50,'10-50',If([Days of Sales]<100,'50-100','>100')))
Create a list for the expression
=If([Days of Sales]<10,'<10',If([Days of Sales]<50,'10-50',If([Days of Sales]<100,'50-100','>100')))
Wow, that simple huh Thanks, often the simplest way is the best (I had been working in my script and everything )
KR,
Stefan