Parameter Equation Based Sheet

This sheet allows you to input equations using multiple parameters. Equations can include the subtraction operator, enabling configuration of positive parameters and negative parameters (parameters to be subtracted).

Overview

Give the sheet a name and select your time frame:

• Month to Date (MTD)
• Last Month to Date (LMTD)
• Year to Date (YTD)

Then select your Data Source.

Step 1

Give your equation a label and select it from the Param Equation dropdown list.
Click ADD EQUATION TO LIST – your equation will be added.

Step 2

To create the equation list, navigate to the Drive tab where you can define your equation as shown below.

Step 3

Add the parameters that need to be included in the Positive Parameters section.
In the Negative Parameters section, include the parameters that need to be subtracted.
Finally, click Submit.