Hi All,
I have requirement in Account Receivable trends wherein I have to show the result of
(OverdueAmount/Total Receivables)
In this case Overdue Amount is the amount which has crossed the credit limit. The overdue amount will fall into various buckets like
Less than 30
31-60
61-90 and so on
I have also provided Aging buckets as list box for selection.
The expression I have used is = Sum(Overdue)/Sum(Amount)
Say for example
Total receivables is $100 and Overdue amount is $70 with the below break-up
31-60 is 20
61-90 is 30
Above 180 days is 20
when I click on 31-60 in the list box I want Expression to calcuate as (20/100), but it is picking up 20/20 and giving me 100%.
Can anyone suggest how can I make denominator to always pick total outstanding and ignore the aging bucket selections.
Regards,
Raghav
