SOLVED
Output data by Ranges of a specific column - Aging Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rdlouviere
5 - Atom
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I created a formula to calculate the aging of a set of data - how old an invoice is. Now I want to take the data and group by a range of this aging to output my data summary.
In other words, I want to create a table that shows how many of each category or exception reason I have that are between 0 and 10 days, 11-30 days, 31-60 days, 61-90 days, 91-120 days, and over 120 days.
Solved! Go to Solution.
Labels:
- Labels:
- Best Practices
- Date Time
3 REPLIES 3
binuacs
21 - Polaris
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rdlouviere can you upload the input file?
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is the input file.
binuacs
21 - Polaris
a week ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rdlouviere Are you looking for something like below
