Maths functions

DIV – Divide one number by another

146 views June 1, 2018 admin 0

Overview

This Custom Field divides one number by another.

Syntax

DIV(Number1, Number2)

Element Description
Number1 The number to be divided.
Number2 The number to divide by.

Examples

DIV(FIELDSTR(Price), 0.8)

The above Custom Field will select a value in a price list (below left) and divide it by 0.8, returning the calculated value (below right).

Price DIV(FIELDSTR(Price), 0.8)
12.00 15.00
15.00 18.75
17.50 21.88
22.75 28.44
100.00 125.00

DIV(FIELDSTR(Quantity), 4)

The above Custom Field will select a value in a price list (below left) and divide it by 0.8, returning the calculated value (below right).

Quantity DIV(FIELDSTR(Price), 4)
25 6.25
100 25.00
80 20.00
1000 200.00
256 64.00

See also

MUL

SUM

SUB

MAX

MIN

AVG

Was this helpful?