Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa tarde!
Alguém já precisou obter apenas a parte "inteira" de algum calculo matemático no qlik? Ex:
=sum(Desl_franquia)*1.4
Este calculo eventualmente me retorna um número do tipo 16,4 , ou 16,8 . Preciso que apareça somente o 16, sem ser arredondado. Olhei várias funções, mas elas ou arredondam para baixo ou para cima, e na verdade não posso ter arredondamentos.
if I understand your question, try with function
floor
this is from Qlik help
floor(x [ , base [ , offset ]])
Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.
Examples:
floor( 2.4 ) returns 2
floor( 2.6 ) returns 2
floor( 3.88 , 0.1 ) returns 3.8
floor( 3.88 , 5 ) returns 0
floor( 1.1 , 1 , 0.5 ) returns 0.5
if I understand your question, try with function
floor
this is from Qlik help
floor(x [ , base [ , offset ]])
Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.
Examples:
floor( 2.4 ) returns 2
floor( 2.6 ) returns 2
floor( 3.88 , 0.1 ) returns 3.8
floor( 3.88 , 5 ) returns 0
floor( 1.1 , 1 , 0.5 ) returns 0.5
Yes, this is it. Strange that I had tried the floor but had not worked when I used.
Anyway, thank you for help, even if it was I needed.