Use row functions to calculate values between rows in a report. Row functions support addition, subtraction, multiplication, and division operations.
In this article, we will cover:
Row Function Behavior
Row functions calculate values by using the raw values from selected report rows.
You can use row functions to:
Add rows
Subtract rows
Multiply rows
Divide rows
The system applies the selected sign reversal setting after the calculation completes.
Creating a Row Function
Open the report.
Select the Rows tab.
Select New.
Select Function from the drop-down list.
-
In the function dialog, select the calculation type:
Sum
Subtract
Multiply
Divide
Press and hold Ctrl.
Select the rows you want to include in the calculation.
Configure the Sign reversal setting as needed.
Save the report.
Sign Reversal Behavior
The system calculates row functions by using raw report values. After the calculation completes, the system applies the selected sign reversal setting.
The following sign reversal options are available:
| Setting | Behavior |
|---|---|
| As shown | Displays the calculated value without changing the sign. |
| Reversal | Reverses the calculated sign before displaying the result. |
Example: Sign Reversal Set to As shown
The following example shows a function calculation that uses the As shown option.
| Row | Raw Value |
|---|---|
| Gross Internal Sales | -9,521,782 |
| Returns & Credits | 33,030 |
Function Calculation
[Gross Internal Sales] + [Returns & Credits]
= [-9,521,782] + [33,030]
= -9,488,753
Sign Reversal Setting
As shown
Result
Report value displays as (9,488,753)
Cell Info displays raw value -9,488,753
Sign value is 1
Example: Sign Reversal Set to Reversal
The following example shows a function calculation that uses the Reversal option.
| Row | Raw Value |
|---|---|
| Gross Internal Sales | -9,521,782 |
| Returns & Credits | 33,030 |
Function Calculation
[Gross Internal Sales] + [Returns & Credits]
= [-9,521,782] + [33,030]
= -9,488,753
Sign Reversal Setting
Reversal
Result
Report value displays as 9,488,753
Cell Info displays raw value 9,488,753
Sign value is 1
Function-on-Function Calculations
You can create row functions that reference other functions.
Example
| Row | Raw Value |
|---|---|
| Function_1 | -9,488,753 |
| Member_1 | 0 |
Function Calculation
[Function_1] + [Member_1]
Sign Reversal Setting
Reversal
Result
Report value displays as 9,488,753
Cell Info displays raw value 9,488,753
Sign value is 1
Alternative Sign Reversal Calculation Model
An alternative calculation approach may be implemented in future versions.
Under this model:
The system calculates the function by using raw cell values.
-
The system multiplies the result by the sign setting:
As shown multiplies by 1
Reversal multiplies by -1
-
Cell Info displays:
The raw calculated value
The sign multiplier value
Example
Raw calculation result: -9,488,753
| Sign Reversal Setting | Report Value | Cell Info Raw Value | Sign |
|---|---|---|---|
| As shown | -9,488,753 | -9,488,753 | 1 |
| Reversal | 9,488,753 | -9,488,753 | -1 |
Row functions use raw report values for calculations.
Sign reversal settings affect the displayed value after calculation.
Cell Info may display different values depending on the sign reversal method used.