Simple calculation returns concatenated value on remote server

[stoyleg]

Hi, I’m doing a relatively straightforward calculation of some database fields - I’m getting the expected results on localhost but when I upload to the remote server it is concatenating instead of summing.

All values are set to INT in the database.

Here is an example of the code…

{{(serverconnect_group_balances.data.query_balances_group.data[0].social_weekly+serverconnect_group_balances.data.query_balances_group.data[0].savings_collected+serverconnect_group_balances.data.query_balances_group.data[0].loan_paid)-(serverconnect_group_balances.data.query_balances_group.data[0].social_distributed-serverconnect_group_balances.data.query_balances_group.data[0].loan_released)}}

Thanks for any help.

[Teodor]

Hello,
Where is this code used?

[stoyleg]

Just inside an html tag - here’s a screenshot…

[Teodor]

Are you sure these values are returned as numbers and not as strings? If they are concatenated then most probably they are strings and you need to use the to number formatter for them.
You can check if they are strings or numbers in the dev tools > network > XHR and check the server action results.

[stoyleg]

It looks like it’s returning numbers…

They are all set to INT in the database and the calculation works fine locally (result: 39855) - it’s just weird why it doesn’t work remotely (result: 55539300).

[Teodor]

Are you sure this is the result on the remote server?
Also are yous suree you have uploaded ALL the files to it?

[stoyleg]

Yes, here are screenshots - the first is what I see locally, the second on the server…

I just tried re-uploading all the files just in case but nothing changed.

[Teodor]

Please send me a link to your page in a personal message so I can check this.