I have a column named “Weights” with values like “1.0” or “2.2” that I use for basic item ordering.
x.0 = default item
x.1 = first optional item
x.2 = second optional item
eg:
1.0 - Include
2.0 - Include
3.0 - Include
3.1 - Exclude
3.2 - Exclude
4.0 ...
Thanks!
I tried briefly just using RIGHT(Weights, 1) just to see if that works, and I get an error… So I think maybe I’m trying to do a text operation on a numeric field… Could be I need to use a FLOOR or something
