Calculation tab

This tab includes the information related to the rv_measure_calc XML that are used in worksheets. The XML determines the process to spread down the measure values to base levels in a worksheet.

The measure calculation eliminates the requirement for populating the rv_measure_calc parameter in each worksheet. The measure calculation can be overridden in individual worksheets by populating the rv_measure_calc parameter in the worksheet.

You must specify this information in the Calculation tab:

Default Worksheet Calculation

The default calculation used for the measure in XML.

Note: The calculation property must be specified in this format:

<property name ="" value="" />

Override

The override calculation used for the measure in XML.

Note:

If specified, this value is used instead of Default Worksheet Calculation.
If not specified, the Default Worksheet Calculation value is used.
The property must be specified in this format:
```
<property name ="" value="" />
```

You can use the Generate option of the corresponding field to populate all the relevant properties for the rv_measure_calc parameter. The value of each property is set to “” which indicates that the default property is used. Also, you can modify the property value, if required.

The XML defined in the Default Worksheet Calculation and Override fields can be overridden by specifying the rv_measure_calc parameter in each worksheet.

The Override field can be used to specify alternative calculations for the measure that overrides the value defined in the Default Worksheet Calculation field.

To remove the properties defined in the Default Worksheet Calculation field, you must copy all the XML from the Default Worksheet Calculation field to the Override field. The property value must be set to Null. For example,

<property name ="total" value="" />