4. Calculated rows in tree

Parent summary rows

• In tree you can aggregate child rows by formula in their parent row.
• It can be done by

  Formula

  and

  Calculated

  attributes in the same way as calculated fixed rows in the example 02-Calculated_Rows.html.
• The aggregate functions by default iterate all immediate children of the parent, but it is also possible to iterate all nested children.
• The children are calculated before their parent, except the calculation order is changed by CalcOrder.
• There is often the same setting for many rows, you can use defaults (one default row <D> for all) to shorten data description.
• If you refer to other cells, you can set row's or cell's attribute Recalc to specify what to recalculate if a user changes the input value.