AnsweredAssumed Answered

How to do calculations when using comma for decimal notation?

Question asked by FernandoP on Oct 27, 2016
Latest reply on Nov 4, 2016 by Matthias_Walter

Hello we are experience a problem with the decimal numbers in a sublist.

We intend to introduce the details of an order using a sublist.

The sublist in supposed calculate the total price of the items, taxes, discount, etc. based on the number of items and the price for each item.

Everything woks until we use decimal numbers, for example for the price of an item. Then the results comes without decimal and multiplied by 100. An example.


PrecioUnitario = 10,5

Unidades = 99

PrecioBruto = PrecioUnitario * Unidades = should be 103,95    But instead it returns 10395


The server is in Spain so we are using comma for decimals and dots for thousands.

The regional configuration of the site correctly set for Spain and is working fine for the rest of the site.

Of course we need to use decimal numbers.

How can resolve this?