topic Formating Number in QlikView

Formating Number

pgalvezt — Wed, 03 Oct 2012 13:44:37 GMT

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 — Wed, 03 Oct 2012 13:47:43 GMT

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

fdelacal — Wed, 03 Oct 2012 13:54:39 GMT

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

but round (9820,80912) will retund 9821

Hope it help you