I've been starting to work on a Aged Balanced report for my manager, but I'm stuck on the algorythm to use to calculate and display relevant information.
Basically I would like to display for each customer account the potential "debt" for different periods (< 30 days, <> 90 days, > 90 days).
Has anyone already worked on such a report ? How did you do?
Thanks a lot.
Former Employee replied
You will have to create 3 formulas to get this :
If Currentdate - < 30 Then amt1:=amt1+ Formula2 Numbervar amt2 If Currentdate - >30 and
Currentdate - < 90 Then amt2:=amt2+ Formula3 Numbervar amt3 If Currentdate - < 30
Now you place these three fomulas in your report and goup by customer.
You will get the values as you desired