How to I add a Constant (for calculations)

Updated on March 14, 2017 in Scorecards
1 on March 14, 2017

Hi, How can I add a constant number that I can use in a set of calculations?  I don’t want the number to added every month but want to refer to it.  It’s a bit like Pi ( π ) in maths.  In my case I have a number that is the highest value possible at any given time.

  • Liked by
0 on March 14, 2017

Hi Luke, 

The application is not really set up to do this as everything is date dependent. However there are a couple of ways to sort-of cheat.  

Example 1

Set up an Unscored measure as an ‘Annual’ measure. Then set the actual value of the measure to your Constant (e.g. π). You can then reference the constant value for 12 months.  The chances are you will need a new value in 12 months so this is the best alternative.

Example 2

Set up a Goal/Red Flag measure and set the ‘Goal’ to your Constant. Set the Red Flag to Zero. You can then use the Goal value in calculations.  the Goal value will persist for as long as the measure exists.  This example is a bit clunky, as you have to remember to use the ‘Goal’ on the calculation.

  • Liked by