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
I could be wrong, but I am pretty sure you can handle this in the field properties. Say you have a 'priority' field with the options listed as High, Medium, Low and field is set to display the options alphabetically. It will display them as High, Low, Medium. However, if you sort the options in they way they are shown in the field, and order them top to bottom = low to high, your report would probably conform. Let me know if that works. #nocoderequired