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 the following example we will be subtracting the Deposit from the Contract Price in order to calculate the Balance Due On Completion.
  1. 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. Responsive screenshot
  2. 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]’. "
The following functions can be used in formulas to perform various operations.
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)