Formula Input Type
Formulas are used to perform mathematical functions within the Leap system in a document. There are four different formula
input types. They all function the same except for the type of data output.
Available in: Leap Pro, Leap Premium, and Leap Enterprise
- Formula (1)
- Number without decimals.
- Formula (1.00)
- Number with decimals.
- Formula ($1)
- Currency amount without decimals.
- Formula ($1.00)
- Currency amount with decimals.
- In order to use Formulas the cells we are performing the formula on need Identifiers. Add an
identifier of ‘Contract Amount’ and an identifier of ‘Deposit’ by clicking Settings on the cells.
- Next in the Balance Due On Completion cell change the Input Type to Formula Currency ($1). In the
Formula field use the Identifiers within square brackets to reference the values and subtract them. Enter
the formula ‘[Contract Amount]-[Deposit]’.
Function | Format/Syntax |
---|---|
Add | [1] + [2] |
Subtract | [2] – [1] |
Multiply | [1] * [2] |
Divide | [2] / [1] |
Raise (To Power) | [1] ** [2] |
Square Root | sqrt([2]) |
Round Up | ceiling([0]) |
Round Down | floor([0]) |
Average | average({[1], [2], [2], [3], [4], [7], [9]}) |
Sum | sum({[1], [2], [2], [3], [4], [7], [9]}) |
Count | count({[1], [2], [2], [3], [4], [7], [9]}) |
Min | min({[1], [2], [2], [3], [4], [7], [9]}) |
Max | max({[1], [2], [2], [3], [4], [7], [9]}) |
Random Number | randomn(10) |
This article is for Dashboard 3.0. Click here to view the help article for version 2.9.