1. User's Guide
  2. Working With Grids
  3. Working With Rows and Columns in Grids
  4. Adding Auto Calculations to Data Rows and Columns
  5. Considerations When Adding Auto Calculations

Considerations When Adding Auto Calculations

  • If errors or missing data exist for members, the previous operations include the member value in the subtotal, but the member value is treated as a zero value.

  • You can use the formatting options without having the calculation done. This enables you to retain the member grouping without calculations such as totals.

  • Since the outermost layer of an auto calculation is the grand total of all rows in the calculation, sorting it is not supported. Sorting on the outermost layer when auto calculations are enabled is ignored. In addition, if you have auto calculations on more than one layer and select Sort, you must sort on all the heading layers (except the outermost layer) which have auto calculations.