Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
9 years ago

Set Order for Summary Crosstabs & Chart Legends

Hello, I'm working with a text formula in my app that looks at a numeric field's value and formulates whether the score for a record is High, Medium or Low.  The formula is working fine, with the ...
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
9 years ago
Tested. Proven. See screenshots:
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
9 years ago
I am diving deep into my automatic memory here, but I believe that the order of true values in your formula will dictate the low to high order.

For example, if your formula looked something like this:

if([this thing]>100,"High",
if([this other thing or the same thing]<=50,"Low","Medium"))

your low to high order would be High, Low, Medium.

if it is possible to change your logic to put them in the correct order, this would probably work. 

I'll test to double check.