Condition Field Name
The field whose value determines if the row is to be included in summary calculation.
If you set the condition field it will be applied only when the corresponding field value is set to "true".
Rules that according to the field type set to condition filed or data value, applying true or false is as follows.
•Bit, Bool type
0 or false is set to false, 1 or true is set to true.
•Numeric type
0 is set to false, except 0 is set to true.
•Other type
Case-sensitive is without reference to null data, false, no, f, n, "0", "0.0", ".0" is set to false and the rest is set to true.
Example
Set to Condition |
No Condition Field Name |
|---|---|
|
|
Calculate summation of Children only for the rows whose Condition field value is 1 (2 + 5 = 7) |
Calculate summation of Children for all rows (5 + 2 + 5 + 0 + 2 = 14) |
