Insight | How to create a Month-over-Month Rate
For more information and tips visit the Eloqua Insight Resource page.
Month-over-Month or Year-over-Year hels you easily spot trends and draw key insights.
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
This seems obvious, right? But it is key to point out because we will need to use the CAST function in order to change the data type to a floating-point type
Tagged:
0