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]

Hello,

for me it looks, like you open 3 brackets, but close only two in rDate boudaries definition.

Put your expression into straight table and give no label. Then on the label field you will see, how expression is evaluated. If it is ok, i expect you should have two dates in this part.\\

regards

Darek