ClientDataSet Wrong Aggregate

[Henry Olive 5]

Good Day

 

Delphi 10,4

 

Table Field Values :

(F1 = 95.615,79 ,  F2 = 6)

 

In Firebird SQL i make a calculation like ( F1 * F2 ) as TOTAL  and

in my query result (In Delphi)  = 573.694,74 which is correct

I have an Aggregate Field in my CDS and it's Expression = SUM(TOTAL)

In my table there is just 1 record and  the Aggregate result = 573.694,73

What am i doing wrong ?

 

Thank You

 

 

 

 

[Serge_G 87]

How are your DataSet fields and Aggregate Field declared ?

I think it's a rounding problem.

[Henry Olive 5]

Thank you Serge, Happy new year

 

Price : Numeric(15,5)

Qty   : Numeric(15,2)

 

Firebird,:  Select  Sum(Price * Qty) as Total  (the result =  573.694,74 )

In Delphi I Created an Aggr.Field and its Expression is  Sum(Total)  (the result =  573.694,73 )

 

Thank You

 

[Olli73 5]

Try a 

 

Select  Sum(Round(Price * Qty, 2)) as Total 

 

or

 

Select  Round(Sum(Price * Qty), 2) as Total 

 

 

And what is the FieldType in ClientdataSet?

 

[Henry Olive 5]

Thank you Olli73, Happy New Year

 

Both Qty & Price fields are  TFMTBCDField;

Select  Sum(Round(Price * Qty, 2)) as Total  gives correct result