11,677
edits
Changes
Updating to match new version of source page
'''RANDOM(10;100)''' - Returns a random number between ''10'' and ''100''
==== ROUND function ====
Returns the rounded value of a value column or value.
Syntax:
ROUND(<value>)
Example:
'''ROUND("Profit")''' - If Profit 10.38 returns 10.00
'''ROUND(15.65)''' - Returns 16.00
==== SQRT function (Square Root) ====
Example:
'''LIKE("Product"; '%anh%')''' - Returns true if the ''Product'' contains the term ''anh'' or false otherwise
== Date Functions ==