I would like to display the % outstanding in a text box so that it shows % of total outstanding that is 0-30 days, 31-60 days, 61-90 days, etc.
The fields that i have to work with are:
Documentdate (date the amount is due)
you can use setanalysis for that..
first of all using interval match get the outstanding for 0-30 days, 31-60 days, 61-90 days, etc.
after that get the percentage outstanding.
Do you have an example, im not sure how i'd use interval match?
Retrieving data ...