Hi Guys - I need your help please: We currently have a report that buckets invoices overdue to the following bands: 0-Current 1-30 Days 31-60 days 90 Days plus
I have now been told to expand the bands to include others and so the revised is:0-Current, 1-30 Days 31-60 days 61-90 days 91-120 days 121 – 180 days 181-365 days 365 days+
For some reason it's not sorting properly (I need it sorting in ascending order as above) - please see screenshot - does anyone have an idea on what i can do please
3 risposte
That's because Text Values sort from Aa-Zz (not nemerically), you need to pad the values with leading 0's , or change the values to something else so that they Aa-Zz sort in the order you want them to display
