Is it possible to use calculated fields in aggregated fields?
- by Jørn E. Angeltveit
Is it possible to use a calculated field in an aggregated field in a TClientDataSet?
object cdsOrders: TClientDataSet
AggregatesActive = True
object cdsOrdersPrice : TIntegerField
FieldName = 'Price'
end
object cdsOrdersCount: : TIntegerField
FieldName = 'Count'
end
object cdsOrdersCalcTotal: TIntegerField
FieldKind = fkInternalCalc
FieldName = 'CalcTotal'
Calculated = True
end
object cdsOrdersAggGrandTotal: TAggregateField
FieldName = 'AggGrandTotal'
Active = True
Expression = 'SUM(CalcTotal)'
end
end
