Maths functions

SUB – Subtract one value from another

110 views June 1, 2018 admin 0

Overview

This Custom Field will subtract the values in the second and subsequent parameters from a first parameter.

Syntax

SUB(Parameter1,Parameter2, Parameter3…)

SUB(100,15,25)

Element Description
Parameter1 A given number.
Parameter2, Parameter3… The number(s) to subtract from the given number.

Examples

SUB(100,15,30) returns ‘55‘.

SUB(FIELDVAL(‘Price’), 18, 4, 3)

Price SUB(FIELDVAL(‘Price’), 18, 4, 3)
30.00 5.00
45.00 20.00
58.75 33.75

See also

MUL

SUM

DIV

MAX

MIN

AVG

Was this helpful?