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.

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]’. Responsive screenshot

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 Rootsqrt([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]})
Maxmax({[1], [2], [2], [3], [4], [7], [9]})
Random Numberrandomn(10)