# How do I add formulas?

To add/edit Formulas you:

- Edit Leaderboard and then click on the Metrics menu
- Add a Connector, select Fomulas and then click save.
- 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.
- To edit Formulas once created, you do Step 1 and then click on the Formula's connector name to be able to edit the 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.