App Connect Data Formatter Support Product Page
Under investigation
sum with decimal value in Mysql
Reported 20 Mar 2018 08:15:29
1
has this problem
20 Mar 2018 08:15:29 Hans Haverlach posted:
HI, I just found out that when using the SUM function in App Connect data formatter, and let it sum the values of a mysql column with TYPE: DECIMAL 10,2 it does not do a good job. I get strange, wrong total values.Does the formatter need an update or do I have to use a different approach.
I already tried to convert to number and then sum, but no succes:
{{sv_transacties.data.query1.sum(`ideal_bedrag.toNumber().formatNumber(2, ".", ",")`)}}
Any help much appreciated.
Replies
Replied 22 Mar 2018 08:54:12
22 Mar 2018 08:54:12 Teodor Kuduschiev replied:
Hello Hans
Please explain what sums are you using, what is the result and provide a link to your page where we can check this.
Please explain what sums are you using, what is the result and provide a link to your page where we can check this.