Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Use floor: floor(9820,45643) will return 9820
Use floor: floor(9820,45643) will return 9820
You can use round: round(9820,45643) will retund 9820
but round (9820,80912) will retund 9821
Hope it help you