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.

Reply to this topic