In the Pivot Section, break totals can be recalculated to have their value equal to the sum of their displayed detail cells. “True computed item totals” use aggregation according to the specified data function and do not rely on the computed item total formula. You also have the option to use the break total cell results derived from the computed item formula applied to the detail cell.
The “Computed” column is defined by the following formula:
(Units % 50) +1
where “%” represents modulo (remainder) operator. In other words, the formula is defined as:
Integer remainder of (“Unit column cell value” /50) + 1
For the Unit column values for each city within a state, the formula works as expected. For example, in the Oakland, CA cell, the formula is:
Units 910
Modulo (remainder) of 910 / 50 = 10
Add 1 to assign a value of 11 (shown above).
For the California “Total” row, the value shown is 41, which is the result of the following formula:
Total “Units” for California = 12390
The Modulo of 41 is not the sum of the displayed cell values for all cities in California, instead it is the modulo formula applied only to the cell containing the “Unit” column city total for California.
To see a break cell total value of 145, use the True Computed Item feature total, which would reference the displayed values in the detail cells (this example assumes a Sum data function):
46 +1 + 11 +1 +46 ( = 145
To use true totals in a break total cell: