Measure Format properties

Property	Description
format	The format for the measure values. The valid format values are '0', '0.00', '0%', '0.00%', 'Date','Datetime', 'KPI'.
highamber	Sets the background to amber when the scenario values >= the value for the corresponding measure.
highred	Sets the background to red when the scenario values >= the value for the corresponding measure.
lowamber	Sets the background to amber when the scenario values <= the value for the corresponding measure.
lowred	Sets the background to red when the scenario values <= the value for the corresponding measure.
highlightgreen	If TRUE, sets the background to green when scenario values are within the amber and red conditions, otherwise displays the normal (white) background color. Applicable where the measure has at least one highamber, or highred, or lowamber, or lowred defined.
kpisize	Indicates if the measure is displayed as an equal sized KPI or a KPI that is proportional to the value. Can be set to either 'proportional' or 'equal'. When set to Proportional, a bar is displayed in the cell. The size of the bar is proportional to the value of the scenarios for the specified measure. The full column width (100%) is displayed for the largest value and scaled down accordingly, based on the proportion to this value. The highamber, highred, lowamber, lowred, and highlightgreen parameters can be utilized to display the appropriate color range (Red, Amber, and Green). If a color range is not specified, the standard chart color pallet is used. Values within the Red range are displayed as a Red bar. Values within the Amber range are displayed as an Amber bar. The highlightgreen parameter must be set to TRUE, consequently all other values are displayed as a Green bar. When set to Equal, an icon is displayed (Red/Amber exclamation marks and a Green check mark). The highamber, highred, lowamber, lowred, and highlightgreen parameters must be utilized to display the appropriate icons. Values within the red range are displayed as a Red exclamation mark. Values within the amber range are displayed as an Amber exclamation mark. The highlightgreen parameter must be set to TRUE, consequently all other values are displayed as a green check mark. By default, the value is set Equal.
total	If TRUE, sets the values to bold. If measure is not defined on the pivot, this condition is ignored.
insertblank	If TRUE, a blank row (if measure is on Left Dim) or blank column (if measure is on Top Dim) is inserted, in the worksheet after the selected measure. If the measure is not defined on the pivot, the same is ignored.
chartnumber (1, 2 and 4)	Overrides the default chart type for this measure. If the measure is included in the charted series this parameter is ignored. Where drawing multiple chart types the data must be retrieved in this order; Area, Column, Line from background to foreground to ensure that each chart type is displayed. The 3 (Pie), 5 (Bar),6 (Map heat), 7 (gauge), 8 (Funnel), 9 Map co-ordinate) chart types, are not supported . The value 0 does not impact this parameter (use rv_measure_graphhide). Note: The gauge properties are defined in rv_measure_format and used only when main chart is set to gauge. The chart number is not required to be set to 7.
secondaxis	When TRUE, the axis is automatically resized to match all the plotted series (where secondaxis = TRUE). If the measure is included in the charted series this parameter is ignored. Default = FALSE, if not defined, plotting the measure on the primary axis, except when the measure format is %, in which case the axis is defaulted to an alternate axis. Whether the % format or alternate axis for measures where secondaxis=TRUE is displayed first, is based on how the data is read when iterating through the measures for the worksheets.
text	Used to create calculated measures and member sets which return a value of text (for example, 1 = A, 2 = B, and so on.). Values are not numerically formatted. If not specified, the value is displayed as null, irrespective of the nullasblank property (ignored where format = text). However, the value returned by the application is a number, the value is then displayed as retrieved and is not formatted. For example: `<Table> <Row name="[DPLS_INVCLASS]"> <Property name="format" value="text" /> </Row> </Table>` Note: If the <> text format and a measure contain text values, format errors occur.
stackedtype	0,1 or 2 (None, Stacked, Percentage). Overrides the default worksheet, stacked type for this measure. If Measure is not included in the charted series this measure is not considered. This is only applicable for chart types, 1,2,4,5 (Column, Line, Area, and Bar). If not defined, the default worksheet, stacked type is used.
nullasblank	When True, the measure is displayed as blank if the value is null/0. If False, null/0 values are displayed as 0 (zero). If state = null (undefined), by default the measure property value is applied. Note: This format is also applied to the charts, that is, null values are not plotted on the charts. When the Measure is of the type, Date or format property = Text (null always displayed as blank) the value is not considered. For example, to display null/0 values as blank cells instead of 0: `<Table> <Row name="[SOP_ERRPER]"> <Property name="format" value="0%" /> <Property name="highamber" value="0.2" /> <Property name="highred" value="0.4" /> <Property name="highlightgreen" value="TRUE" /> <Property name="nullasblank" value="TRUE" /> </Row> </Table>`
trendmeasure	The measure that must be used as the trend measure for the current measure. Only applicable if the default chart type = 7 (Gauge). If the measure is not included in the charted series, the trend measure is not considered.
mingaugeaxis	Indicates the minimum axis value to be displayed on a gauge chart. This is only applicable for the chart type = 7 (Gauge). The value is specified as a number. If the value is not defined, the minimum axis value on the gauge chart is displayed as 0. If the measure is not included in the chart series, the mingaugeaxis is not considered.
maxgaugeaxis	Indicates the maximum axis value to be displayed on a gauge chart. This is only applicable for the chart type = 7 (Gauge). The value is specified as a number. If the value is not defined, the maximum axis value on the gauge chart is displayed as 100. If the measure is not included in the chart series, the maxgaugeaxis is not considered.
displayValue	If the value is set to: True: the values for the measure is displayed as label on the chart. False (or not defined): the values are not displayed on the chart; however, you can view the values using the tool-tip. Percentage: the values are displayed in % format. This property is not applicable for rv_chart_number = 7 (Gauge) as the value is always displayed.

format

The format for the measure values. The valid format values are '0', '0.00', '0%', '0.00%', 'Date','Datetime', 'KPI'.

highamber

Sets the background to amber when the scenario values >= the value for the corresponding measure.

highred

Sets the background to red when the scenario values >= the value for the corresponding measure.

lowamber

Sets the background to amber when the scenario values <= the value for the corresponding measure.

lowred

Sets the background to red when the scenario values <= the value for the corresponding measure.

highlightgreen

If TRUE, sets the background to green when scenario values are within the amber and red conditions, otherwise displays the normal (white) background color. Applicable where the measure has at least one highamber, or highred, or lowamber, or lowred defined.

kpisize

Indicates if the measure is displayed as an equal sized KPI or a KPI that is proportional to the value. Can be set to either 'proportional' or 'equal'. When set to Proportional, a bar is displayed in the cell. The size of the bar is proportional to the value of the scenarios for the specified measure. The full column width (100%) is displayed for the largest value and scaled down accordingly, based on the proportion to this value. The highamber, highred, lowamber, lowred, and highlightgreen parameters can be utilized to display the appropriate color range (Red, Amber, and Green). If a color range is not specified, the standard chart color pallet is used. Values within the Red range are displayed as a Red bar. Values within the Amber range are displayed as an Amber bar. The highlightgreen parameter must be set to TRUE, consequently all other values are displayed as a Green bar. When set to Equal, an icon is displayed (Red/Amber exclamation marks and a Green check mark). The highamber, highred, lowamber, lowred, and highlightgreen parameters must be utilized to display the appropriate icons. Values within the red range are displayed as a Red exclamation mark. Values within the amber range are displayed as an Amber exclamation mark. The highlightgreen parameter must be set to TRUE, consequently all other values are displayed as a green check mark. By default, the value is set Equal.

total

If TRUE, sets the values to bold. If measure is not defined on the pivot, this condition is ignored.

insertblank

If TRUE, a blank row (if measure is on Left Dim) or blank column (if measure is on Top Dim) is inserted, in the worksheet after the selected measure. If the measure is not defined on the pivot, the same is ignored.

chartnumber (1, 2 and 4)

Overrides the default chart type for this measure. If the measure is included in the charted series this parameter is ignored. Where drawing multiple chart types the data must be retrieved in this order; Area, Column, Line from background to foreground to ensure that each chart type is displayed. The 3 (Pie), 5 (Bar),6 (Map heat), 7 (gauge), 8 (Funnel), 9 Map co-ordinate) chart types, are not supported . The value 0 does not impact this parameter (use rv_measure_graphhide).

Note: The gauge properties are defined in rv_measure_format and used only when main chart is set to gauge. The chart number is not required to be set to 7.

secondaxis

When TRUE, the axis is automatically resized to match all the plotted series (where secondaxis = TRUE). If the measure is included in the charted series this parameter is ignored. Default = FALSE, if not defined, plotting the measure on the primary axis, except when the measure format is %, in which case the axis is defaulted to an alternate axis. Whether the % format or alternate axis for measures where secondaxis=TRUE is displayed first, is based on how the data is read when iterating through the measures for the worksheets.

text

Used to create calculated measures and member sets which return a value of text (for example, 1 = A, 2 = B, and so on.). Values are not numerically formatted. If not specified, the value is displayed as null, irrespective of the nullasblank property (ignored where format = text). However, the value returned by the application is a number, the value is then displayed as retrieved and is not formatted. For example:

<Table> <Row name="[DPLS_INVCLASS]"> <Property name="format" value="text" /> </Row> </Table>

Note: If the <> text format and a measure contain text values, format errors occur.

stackedtype

0,1 or 2 (None, Stacked, Percentage). Overrides the default worksheet, stacked type for this measure. If Measure is not included in the charted series this measure is not considered. This is only applicable for chart types, 1,2,4,5 (Column, Line, Area, and Bar). If not defined, the default worksheet, stacked type is used.

nullasblank

When True, the measure is displayed as blank if the value is null/0. If False, null/0 values are displayed as 0 (zero). If state = null (undefined), by default the measure property value is applied.

Note: This format is also applied to the charts, that is, null values are not plotted on the charts. When the Measure is of the type, Date or format property = Text (null always displayed as blank) the value is not considered.

For example, to display null/0 values as blank cells instead of 0:

<Table>
<Row name="[SOP_ERRPER]"> 
<Property name="format" value="0%" /> 
<Property name="highamber" value="0.2" />
<Property name="highred" value="0.4" />
<Property name="highlightgreen" value="TRUE" />
<Property name="nullasblank" value="TRUE" />
</Row>
</Table>

trendmeasure

The measure that must be used as the trend measure for the current measure. Only applicable if the default chart type = 7 (Gauge). If the measure is not included in the charted series, the trend measure is not considered.

mingaugeaxis

Indicates the minimum axis value to be displayed on a gauge chart. This is only applicable for the chart type = 7 (Gauge). The value is specified as a number.

If the value is not defined, the minimum axis value on the gauge chart is displayed as 0.

If the measure is not included in the chart series, the mingaugeaxis is not considered.

maxgaugeaxis

Indicates the maximum axis value to be displayed on a gauge chart. This is only applicable for the chart type = 7 (Gauge). The value is specified as a number.

If the value is not defined, the maximum axis value on the gauge chart is displayed as 100.

If the measure is not included in the chart series, the maxgaugeaxis is not considered.

displayValue

If the value is set to:

True: the values for the measure is displayed as label on the chart.
False (or not defined): the values are not displayed on the chart; however, you can view the values using the tool-tip.
Percentage: the values are displayed in % format.

This property is not applicable for rv_chart_number = 7 (Gauge) as the value is always displayed.