Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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)
OutstandingValue
Thanks,
Sunil
hi,
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.
HTH
Sushil
Thanks Sushil,
Do you have an example, im not sure how i'd use interval match?
Thanks,
Sunil