AR Aging Report
SummaryAR Aging Report
I am doing a AR Aging Report using OTBI.
For example: AR aging report has following columns: Customer Name, Transaction Date, Transaction Number, Remaining Amount Due, 0-30 Days, 31-60 Days, >60 Days.
How can I sum up the "Remaining Amount Due" if Current_Date - Transaction Date <= 30 and put it under "0-30 Days" column? It prompts up an error for this. Please kindly advice. Many thanks.
CASE WHEN current_date - "Payment Schedules Details"."Transaction Date" < 30 THEN sum("Payment Schedules"."Accounted Amount Due Remaining") ELSE 0 END