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

Insight (OBIEE) Tips | How to create a Month-over-Month Rate

Received Response
44
Views
1
Comments

One of the most common questions I get, when it comes to Insight, is about creating growth rates; in particular Month-over-Month or Year-over-Year. This allows users to identify trends and key takeaways.

In this post, I'll provide an overview of how to create this calculation, in case you'd like to add it to your own reports.

What is the calculation for MoM?

((Current Month -Previous Month)/Previous Month)*100

Key points to consider before we start to build out the formula in Insight:

  1. We will need to use values in other rows
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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