Formating Number

[pgalvezt]

Hello, I'm trying to convert

9820,45643 in integer (9820). But still showing the rest of numbers.

The object is a text box

=(Sum(If(IDCode='A' and Año=xAñoMax, Saldo,'#.##0,00'))/Divisor)-(Sum(If(IDCode='B' and Año=xAñoAnt, Saldo,'#.##0,00'))/Divisor)

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Use floor: floor(9820,45643) will return 9820

[fdelacal]

You can use round: round(9820,45643) will retund 9820

                    but    round (9820,80912) will retund 9821

Hope it help you