How do I add, edit and delete formulas?

Formulas allow you to produce more complex metrics such as ratios (RTs per 100 tweets for example) or (% target achieved).

To add/edit Formulas, navigate to your admin dashboard of your scorecard and then:
  1. Go to scorecard settings -> score algorithm.
  2. Click on the +Add Formulat button
  3. This will then take you to the screen to add the Formulas page, where you can enter a Formula. This is made up of calculator style operators (+ - / * ) and brackets. You can use any other metric as an input into your formula. 
  4. To edit Formulas once created, you do Step 1 and then highlight the Formula by clicking on its name within the Metric Tree, and then click on Edit Formula
  5. To delete a Formula from your score algorithm, repeat Step 4, but instead of Edit Formula, click on Edit Metric, go to the bottom of the page, click on the link which says "This metric is derived from xxxx" and on the resulting page, click on the red button "Delete Formula"


Available Functions

Our Formula language is based on the OpenFormula standard and supports the following functions:

Rounding Functions

ROUND


Summary: Rounds the value X to the nearest multiple of the power of 10 specified by Digits.
Syntax: ROUND( Number X [ ; Number Digits = 0 ] )

ROUNDDOWN


Summary: Rounds the value X towards zero to the number of digits specified by Digits
Syntax: ROUNDDOWN( Number X [ ; Integer Digits = 0 ] )

ROUNDUP


Summary: Rounds the value X away from zero to the number of digits specified by Digits
Syntax: ROUNDUP( Number X [ ; Integer Digits = 0 ] )


If there is an openformula function you require we'd be happy to implement it for you. Please suggest it.

Feedback and Knowledge Base