Summary Reports - help with grouping

Question

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)] &lt; 31, "0-30 days",If([Days in AR (Age)] &gt; 30 and [Days in AR (Age)] &lt; 61, "31-60 days",If([Days in AR (Age)] &gt; 60 and [Days in AR (Age)] &lt; 91, "61-90 days",If([Days in AR (Age)] &gt; 90 and [Days in AR (Age)] &lt; 181, "91-180 days",If([Days in AR (Age)] &gt; 180, &nbsp;"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.&nbsp; Any ideas how I can achieve this?&nbsp; Maybe a Rich text field or something?

Any help is greatly appreciated!
Kelly

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

markshnier__you · Answer

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.&nbsp;
If([Days in AR (Age)] &lt; 31, " 0-30 days",

note the space in front of the zero.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

kellylyons1 · Answer

Thanks Mark!------------------------------Kelly Lyons------------------------------

Forum Discussion

Summary Reports - help with grouping

2 Replies

Related Content

Summary Report

How to add more rows for Group by for a summary report?

Using Groups

YR over YR Summary Report

Summary Table

Recent Discussions

Join multi-line text field to one line

Create a formula duration over 5 years

Formula URL - Edit then Add

Share your feedback on the new Qrew Discussions

Date value changes when copied to new table with pipeline.