Decimals in text box

[pgalvezt]

Hello! I'm trying to eliminate the decimals

=Num(Sum(If(IDCode='39000' and Año=xAñoMax, Saldo))/Divisor)/Num(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor)  *100

I used #.##0,0 but does't work

Display 21,234556 I want 21.2

Thanks!

[MayilVahanan]

HI

Try this

=Num(your expression, '#.##')

or

in number tab-> use fixed:2 decimal

Hope that helps

[Gysbert_Wassenaar]

Or you can use round in your expression: round(21.234556, 0.1) returns 21.2

[pgalvezt]

I tried but show the same number.

=(Round(Sum(If(IDConcepto='39000' and Año=xAñoMax, Saldo))/Divisor))/(Round(Sum(If(IDConcepto='19000' and Año=xAñoMax, Saldo))/Divisor) )

or

=(Sum(If(IDConcepto='39000' and Año=xAñoMax, Saldo, '#.##'))/Divisor)/(Sum(If(IDConcepto='19000' and Año=xAñoMax, Saldo, '#.##'))/Divisor)*100

Nothing happened.

[Gysbert_Wassenaar · Accepted solution]

Put the round on the outside:

=round(Num(Sum(If(IDCode='39000' and Año=xAñoMax, Saldo))/Divisor)/Num(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor)  *100, 0.1)