ion Learning Help Site

Formulas

Updated

This section is still very much in draft form.

General Notes about Formulas

  • Formulas are case sensitive.
  • Formulas only work across, not down.
  • Formulas can only be used for data on a data wall.
  • Formulas do not currently work when using another formula column as an input.
  • Formulas will not calculate if a score/input is blank for an input. The formula will output a blank.
Formulas
Formula Description/ Comments Example(s)
isNumeric(expression)
Returns TRUE if the entire expression is recognized as a number, otherwise it returns FALSE.

Returns FALSE if the expression is a date.
Example Inputs: 53, 459.95
isNumeric(c1)
Output: TRUE

Example Input: 53L
isNumeric(c1)
Output: FALSE
isDate(expression)

Possible Inputs: 04/28/2022, April 28, 2022, 04.28.22, 04.28.2022
Output: TRUE

Input:
Output:

isNothing(variable)

Input:
Output:
isBetween(variable1, variable2)

Input:
Output:
notBetween(variable1variable2)

Input:
Output:
mod(variable1variable2)

Input:
Output:
isLessThan(variable1variable2)

Input:
Output:
isGreaterThan(variable1variable2)

Takes into account nulls, which means that the output will be blank if a null exists.
Input:
Output:
isLessThanEqual(variable1variable2)

Input:
Output:
isGreaterThanEqual(variable1variable2)

Input:
Output:
isEqual(variable1variable2)

Input:
Output:
mid(variablestartlength)

Input:
Output:
left(variablelength)

Input:
Output:
right(variablelength)

Input:
Output:
indexOf(variablelookup)

Input:
Output:
toDouble(variable)

Input:
Output:
toInteger(variable)

Input:
Output:
toString(variable)

Input:
Output:
rtrim(variable)

Input:
Output:
ltrim(variable)

Input:
Output:
formatNumber(variablenumDigitsAfterDecimal)

Input: 83.855
formatNumber(x,1)
Output:83.9
toDate(variable)

Input:
Output:
coalesce([variablevariablevariable])

Input:
Output:
len(variable)

Input:
Output:
replace(variablefindreplace)

Input:
Output:
parseDate(variableformat)

Input:
Output:



Operators
Operator/ Syntax
Description/ Comments Example
+ Add c1+c2
- Subtract c1-c2
* Multiply c1*c2
/ Divide c1/c2
() Parentheses (c1+c2)/2



Previous Article Data Wall Editor
Next Article Getting Started with Dashboards