Insight (OBIEE) Tips | How to create a Month-over-Month Rate
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:
- We will need to use values in other rows