Timestampadd

User_GKKR511111

Summary

Revenue for Rolling months?

Content

How to calculate Revenue for Rolling 12 months, Rolling 24 Months and Rolling 36 months from current date in OAC? 

Version

OAC

Aman Jain-Oracle

Hello Danish,

you can use the PERIODROLLING function in OAC where you specify a start and end period in the function.

The PERIODROLLING function lets you perform an aggregation across a specified set of query grain periods, rather than within a fixed time series grain.

Below is the PERIODROLLING function format:

PeriodRolling(<<Measure>>, <<Starting Period Offset>>, <<Ending Period Offset>>)

Hope this helps!

Best Regards,
Aman Jain