After several hours of staring at this, taking the dog out for a walk to clear my head, and coming back to it, I finally solved a problem that I thought I would share.
I have a VC which is a enum column. Options are:
- Not started
- Awaiting ID check
- In progress
- Results received
The actual value is set via switch statement in the formula expression. I have a table view that groups the rows based upon that VC with the group order as ascending. What confused me was that "In Progress" always came last even if I tried descending.
After lots of trying things out I finally solved the mystery. The enum is case sensitive. My expression was setting the value to "In Progress" and not "In progress" and hence it was being treated as another value even though the option to allow other values was not set.
Another lesson learnt!
LinkedIn
Twitter
