Page 1 of 1

AppGini 5.81 Calculated field

Posted: 2019-10-19 18:16
by Moh Youba
Hello

I am using AppGini calculated field to get calculation for qty * price. Following example given by Ahmad all is working well. In the result I get this format "4000" what I need is this format " 4 000".

Here the code I am using

SELECT `transactions`.`qts` * `transactions`.`prix`
FROM `transactions`
WHERE `transactions`.`idtransaction`='%ID%'

Any help please

Thank you