Most Commonly Used Custom Scorecard Formulas


Related article- How to Use Custom Scorecard Formulas

Simple Custom Operators

Details

Custom formulas can be used for a variety of purposes. One example might be for a supervisor to track their direct reports. If each direct report has its own Sales measurable, such as Sales Tom and Sales Eileen, these 2 separate measurables can be summed for a 'Sales Total' measurable that may be owned by the supervisor. The first example below would be created and owned by the supervisor. Changes to the Sales Tom and Sales Eileen measurables would automatically adjust on the 'Sales Total' measurable.

Parentheses and combining

Reusing measurables 

Weekly offsets

Details

This is helpful if you wanted to display a running total or average for a set amount of weeks. To access the offset option, on your ‘Items Sold’ measurable, inside the formula, click the small triangle to the right of the words ‘Items Sold’. The below formula would display a running average of the Items Sold measurable for the past 3 weeks.

Year over year ratio

Details:

Note that this is dividing the current week's value by the value from 52 weeks ago. See the above formula for details on offsetting the week.

Rounding the result

Details

Sometimes a formula will have an excess number of digits when there is only a need to show just a few numbers after the decimal. Use the ROUNDK ( A ; B ) expression to shorten the results of a formula. The ‘A’ portion is the formula, the ‘B’ is the maximum number of spaces a number can display after the decimal point.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.