Rounding in formula

[tothewine]

How do I get a formula without rounding?

[shalmaxb]

By default calculating interger and float happens without rounding. In float, you have to set the needed amount of decimals in the field itself.

[tothewine]

this is the result of this formula

suPrezzoPromo = number\format((((importoOffertaIvaEsclusa/prezzoCodiceIvaEsclusa)-1)*100));



with this field setting

[shalmaxb]

Guessing from your example, you have an article with normal price, which you offer also as promo with a percentage (both adding% and substracting% ??).

So from the normal price you set any + or - percentage and then want to display the promo price.

If this is the case, you do not need formatting formula, it is more simple:

suPrezzoPromo = normalPrice + ((normalPrice/100)*percentValue); 

If you input a positive value, the percentage amount will be added to the normal price. If you input a negative value, it will be substracted.

Your examples, calculated with this formula:

5420,00 1% 5474,20
4000,00 -5% 3800,00
3800,00 18% 4720,00
3800,00 0% 3800,00

I hope it helps.