Need help with due amount calculation

[usamabinsadiq]

Hi,

I have data fields like: (date field is calculated, it has all the dates from min(order_date) till today)

date,

order_date,

Due_date,

invoice date,

invoice_amount,

customer_name,

.....

I need to calculate total due invoice_amount (due_date < date) in master items, can anybody help with it.

Thanks.

[msKarthikeyan]

Hi ,

Do u want to calculate due items at customer level?

-Karthik 

[usamabinsadiq]

yes I want to get customer level, due amount. but amount must be calculated after due date is passed like (due_date < max(date))

[lorenzoconforti]

According to your data structure there is one date per record so due_date < date will work (technically) but it doesn't look like it is what you are looking for

Can you explain what the date field includes and in which tables does it appear? Do you have a master calendar built on this?

[usamabinsadiq · Accepted solution]

Thank you guys, I resolved it by my own using,

sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])

but thank you all.