2,155
edits
Changes
no edit summary
'''RANDOM(10;100)''' - Returns a random number between ''10'' and ''100''
==== ROUND function ====
<!--T:172-->
Returns the rounded value of a value column or value.
<!--T:173-->
Syntax:
ROUND(<value>)
Example:
'''ROUND("Profit")''' - If Profit 10.38 returns 10.00
'''ROUND(15.65)''' - Returns 16.00
==== SQRT function (Square Root) ==== <!--T:174-->
Example:
'''LIKE("Product"; '%anh%')''' - Returns true if the ''Product'' contains the term ''anh'' or false otherwise
== Date Functions == <!--T:181-->