KellyLyons1
10 months agoQrew Cadet
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)] < 61, "31-60 days",
If([Days in AR (Age)] > 60 and [Days in AR (Age)] < 91, "61-90 days",
If([Days in AR (Age)] > 90 and [Days in AR (Age)] < 181, "91-180 days",
If([Days in AR (Age)] > 180, "180+ days")))))
The issue I am having is the way it displays here:
Obviously I do not want the 180+ days where it is, I want it at the at the end of the groups. Any ideas how I can achieve this? Maybe a Rich text field or something?
Any help is greatly appreciated!
Kelly
------------------------------
Kelly Lyons
------------------------------