Formula Input Type
Formulas are used to perform mathematical functions within the SalesPro system in a document. There are four different formula
input types. They all function the same except for the type of data output.
- 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.