Reference: Calculation Element Properties

Last updated
Save as PDF

Describes the properties available for managing calculations for a matrix report.

You can add calculation elements to a matrix report to show variances in data or metrics and percentages. See Matrix Report Calculations.

This table describes the properties available for managing a calculation element using the Element Properties dialog. To access the Element Properties dialog, right-click a calculation element and selecting Properties.

Field	Description
Label	Sets the name for the element as it displays in the report. The field appears for all calculation elements.
Code	Sets a code for reference purposes. For example, use the code to refer to the element in a custom calculation formula. The field appears for all calculation elements.
Display As	Sets the format for displaying the result. Select one: Account's display type. Displays the result as a number or percent based on the Display As setting for the account under Modeling. See Add and Edit Accounts. Available for all elements except GL accounts. Value. Displays the percent values as numbers. For example, 5% shows as 0.05. Percent. Displays the number and currency values as percentages. For example, 5 shows as 500%. The field appears only for the Difference and Custom calculation elements. The Account's display type property does not apply to a Difference calculation.
Reverse Sign	Changes the sign of the result from negative to positive or the reverse. For example, you can show a negative variance as a positive result for an Expense account. The field appears only for the Difference and Custom calculation elements. Also, this option is only available for non-accounts calculations such as versions or time. When selected, reverses the sign of the expenses, liabilities, and equities.
Difference Options	Sets which elements represent the following factors in a difference calculation: The number to subtract The number from which to subtract The field appears only for the Difference calculation element.
Connected to Parameter	Indicates whether the Difference element is connected to a report parameter. When the report parameter changes, the variance data updates See Report Parameters. The field appears only for the Difference calculation element.