Custom Calculations (Report-level Calc)

Hardik Chheda Updated by Hardik Chheda

After creating the business view from the dataset, if you want to apply some calculations on the combined dataset, you can create those calculations on the fly and add them as a new column in the dataset.

  1. On the Calculated Columns page, click the Create New Calculation button.
    The Create new Calculation dialog box appears with the list of columns from the selected business view.
  2. In the Name field, enter the name of the calculated column.
  3. Click the Calculation type option for your calculated column.
    1. Row level: Expressions result in a new column of unaggregated dataset columns that are computed for each row.
    2. Column level: Expressions result in a new value that is aggregated by columns within a dataset.
  4. Click in the Formula text field and enter the calculations.
    Refer the columns from the business view and use them in your formula. Ensure that you use the exact names of those columns considering their case, like upper case, lower case, or title case.
    Also, refer the formula examples given to understand how to enter the formula.
  5. Click Validate to validate the given formula.
  6. After validating the formula, click the Create button.
    Tellius creates the new calculated column and adds it to the dataset of the business view.
  7. After the business view is successfully published for the new column, go to the Data page and check that your new column is added in the table.

Did we help you?

Learnings (from Teach Me)

Predictions on BV