Creating and editing column formulas is the same as in UM Analytics. Creating column formulas is useful if aggregation or calculation is needed in the report. For example, the IFNULL formula is useful when a measure column contains null values; or, COUNT is useful for aggregating values of a column.
Click the Columns tab in the header area of the Unify BI workspace.
Locate the column and click the gear icon. The edit column window is displayed.
Edit the name of the column at the top.
Enter the formula in the formulas area.
Click the book icon to open the list of all formulas to see the correct syntax.