accounts receivable aging

[#1]

Hi,

Can anyone please help me to figure out how to calculate accounts receivable aging using set analysis?

I am using the following syntax but it is not working.

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} >}Sales - Costs)

where

isAccountInvoiced={'1'} -  selects all accounts invoiced (all accounts invoiced have a value of 1)

rDate - is the date MM/DD/YYYY

rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} - syntax used for accounts receivable age between 121-150 days

Thank you

[#2 · Accepted solution]

The following syntax can be used to calculate accounts receivable aging

1-30 days

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-1)<=$(=DateMax(rDate)-30)"} >}Sales - AmountPaid)

31-60 days

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-31)<=$(=DateMax(rDate)-60)"} >}Sales - AmountPaid)

91-120

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-91)<=$(=DateMax(rDate)-120)"} >}Sales - AmountPaid)

121-150 days

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=DateMax(rDate)-121)<=$(=DateMax(rDate)-150)"} >}Sales - AmountPaid)

I used DateMax(rDate) instead of Date(Max(rDate)) and it worked