Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you guys, I resolved it by my own using,
sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])
but thank you all.
Hi ,
Do u want to calculate due items at customer level?
-Karthik
yes I want to get customer level, due amount. but amount must be calculated after due date is passed like (due_date < max(date))
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?
Thank you guys, I resolved it by my own using,
sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])
but thank you all.