Format tab

This tab includes the information related to the rv_measure_format XML that is used in worksheets. The XML determines the process to represent the measure values in the worksheet.

The measure format eliminates the requirement for populating the rv_measure_format in each worksheet. The measure format can be overridden in individual worksheets by populating the rv_measure_format.

You must specify this information in the Format tab:

Default Worksheet Format

The default format for the measure in XML.

Note:

The property must be specified in this format:
```
<property name ="" value="" />
```
This field cannot be modified for the system defined measures.

Override

The override format for the measure in XML.

Note:

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

You can use the Generate option next to the corresponding field to populate all the relevant properties for the rv_measure_format 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.

If the values are not specified for Default Worksheet Format and Override fields, the basic format defined in the Format field of the Details tab is used. If required, you can define additional formats in the rv_measure_format parameter for each worksheet using the measure.

The Override field can be used to specify alternative formatting for the measure that overrides the properties defined in the Default Worksheet Format field. To remove the properties defined in the Default Worksheet Format field, you must copy all the XML from the Default Worksheet Format field to the Override field. The property value must be set to Null. For example,

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

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