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 ...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
You might try using an HTML field or a text formula that contains leading spaces to force the apparent sort order you want.

​ ​ ​ High

​ ​ Medium

​ Low

where ​ is the numeric character entity for a unicode zero width space.
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
The Mongolian Vowel Separator  looks promising: ᠎

As does the Invisible Separator: ⁣

Also, the Zero-Width Joiner works: ‍

Lots of possibilities to try!