Page Comparison

...

• Visibility: Select if the row should be displayed on the dashboard table/chart. Select "hidden" if the result is only used for calculations.
• Formula: The calculation of the result of the row based on row results, variables and static numbers. All basic arithmetic operators (+-*/) as well as brackets can be used.
  • Variables: 
    The variable will be substituted by the value of a report variable. Keep in mind, that this only works with number variables.
    Format: $<variable_name>
  • Row results:
    Similar to a variable, the variable will be substituted by the result of a row. A type "Formula" row has to be classified before the current row (sorting). Keep in mind, that this only works on single column results
    Format: $<row_name>
  • Functions (build in):
    • ifnull($<varible/row_name>, <alternative value>): if the <variable/row_name> is 0, the <alternative_value> is used

This tutorial video creates a report that analyses Desexing- Castrations and Speys. A formula is used to add together the desexing total and targets are created based on national averages.