Forum Discussion

Qrew Cadet

9 months ago

Summary Reports - help with grouping

I have a summary report that groups my Rolling AR using the field [A/R Age Group] using this formula: If([Days in AR (Age)] < 31, "0-30 days", If([Days in AR (Age)] > 30 and [Days in AR (Age)] < 6...

MarkShnier__You

Qrew Legend

This is a common problem with an easy workaround. They sort alphabetically. So just put a leading space in front of the ones that you want to be first and then the 180 day column will end up being last.

If([Days in AR (Age)] < 31, " 0-30 days",

note the space in front of the zero.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

KellyLyons1

Qrew Cadet

9 months ago

Thanks Mark!

------------------------------
Kelly Lyons
------------------------------