cf field not showing 2 decimals

functions are processed within the SELECT command

( 
SELECT printf("%.2f",  sum(Total) ) FROM TableLines WHERE id_TableOrders = TableOrders.id)
)  

You try chose Field type (TEXT)  in CfTotal  not Real

Hi
thank you for answer, i try it but nothing cannot get decimals

I send fixed file  your project

in calculate field  file Type  choose type (TEXT)  don.t CURRENCY

Hi
now when i change to text sum not working then,look at screenshot

Hi Derek, Agusecc, k245

There is no error in the calculated field.
I have a different decimal separator. There is indeed a difference.

He can use:

procedure FormMain_TableGridInvoices_OnChange (Sender: TObject);
begin
  TNxNumberColumn(FormMain.TableGridInvoices.Columns[9]).FormatMask := '#,##0.00';
end;

And I think you can do without printf in the calculated field.

Hi Sparrow,
You have excellent eye-sight to spot the ',' instead of '.'! 
Derek.