How to Calculate MTD and YTD in Oracle BI Analysis Reports
Summary
How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent
Hi,
I am trying to create a budget vs actual comparison report for projects using Project Costing Actual Costs Real Time and Project Control Budgets Real Time in OTBI.
Could any help how do i calculate MTD and YTD value for budget and Actual. Attached the screenshot of the columns that i have added using both the subject area. Kindly let me know if i need to any column as well.
Regards,
Avesh Ganodwala
Tagged:
0