ABS(): ABS([Profit]) : Return absolute value

CEILING(): CEILING([Discount]) : Round up to nearest int

FLOOR(): FLOOR([Discount]) : Round down

ROUND(): ROUND([Sales],0) : Round to N decimals

POWER(): POWER([Sales],2) : Raise to exponent

SQRT(): SQRT([Sales]) : Square root

LOG(): LOG([Sales]) : Natural log

LOG10(): LOG([Sales],10) : Base 10 log

PI(): PI() : Constant

RANDOM(): RANDOM() : Random number 0-1 (v2024.1)

MOD(): MOD([Row ID],2) : Modulo remainder

SIGN(): SIGN([Profit]) : Return 1,0,-1 sign value
Previous Next