ion Learning Help Site

Formulas

Updated Feb 03, 2021

This section is still very much in draft form.

Formula Example
isNumeric(var)
isDate(var)
isNothing(var)
isBetween(var1, var2)
notBetween(var1, var2)
mod(var1, var2)
isLessThan(var1, var2)
isGreaterThan(var1, var2)
isLessThanEqual(var1, var2)
isGreaterThanEqual(var1, var2)
isEqual(var1, var2)
mid(var, start, length)
left(var, length)
right(var, length)

indexOf(var, lookup)
toDouble(var)
toInteger(var)
toString(var)
rtrim(var)
ltrim(var)
formatNumber(var, numDigitsAfterDecimal)
toDate(var)
coalesce([var,var,var])
len(var)
replace(var, find, replace)
parseDate(var, format)

Value 2
Previous Article Data Wall Editor
Next Article Getting Started with Dashboards