You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Calculate MTD and YTD in Oracle BI Analysis Reports

Received Response
229
Views
2
Comments
edited Dec 4, 2018 6:53AM in Reporting and Analytics for ERP 2 comments

Summary

How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real Time

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!