Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to Calculate MTD and YTD in Oracle BI Analysis Reports — Cloud Customer Connect
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
43
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!