topic Re: Expression returning wrong result in QlikView

Expression returning wrong result

Mon, 30 Mar 2015 19:57:06 GMT

Hi,

Does anybody ever seen this problem?

Expression:

num([Valor Conta 2],'0.0') - rangesum(num([Valor Recebido 2],'0.0'),num([Valor Glosa 2],'0.0'),num([Valor Perda 2],'0.0'),num([VL_PAGO_RETORNO 2],'0.0'),num([VL_GLOSADO_RETORNO 2],'0.0'))

2266,15 - (2142,24+123,91) = 4,54747350..... should be zero!

Re: Expression returning wrong result

Anonymous — Mon, 30 Mar 2015 20:06:42 GMT

It is close enough to 0 - see this "e-013"

Re: Expression returning wrong result

Mon, 30 Mar 2015 20:17:25 GMT

The problem is that I have some conditions that depend on this result.

Do you have any tips on how to fix this?

Re: Expression returning wrong result

Anonymous — Mon, 30 Mar 2015 20:28:07 GMT

Maybe using round(). And no need for num() for each part, it is only for presentation but doesn't change underlying values.

round(
[Valor Conta 2] - rangesum([Valor Recebido 2], [Valor Glosa 2], [Valor Perda 2], [VL_PAGO_RETORNO 2], [VL_GLOSADO_RETORNO 2])
,0.01)

Re: Expression returning wrong result

Mon, 30 Mar 2015 20:31:04 GMT

Hi,

Try rounding to something reasonable.

Round(num([Valor Conta 2],'0.0'),0.001) -Round(rangesum(num([Valor Recebido 2],'0.0'),num([Valor Glosa 2],'0.0'),num([Valor Perda 2],'0.0'),num([VL_PAGO_RETORNO 2],'0.0'),num([VL_GLOSADO_RETORNO 2],'0.0')),0.001)