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 | How to create a Month-over-Month Rate

edited Oct 28, 2024 3:30PM in Eloqua 1 comment

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:

  1. 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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