Values change when you select the product

[fftec_fftec]

Hello people,

I have a table in QlikView with the dimension Product and the expression stock.

when selecting any product the stock value changes.

I will list the example here

== Expression I'm using ==

IF(PRODUTO.B1_PRV1 = 0,

sum(PRODUTO.QATU_REAL * (PRODUTO.B1_UPRCDOL * vFator )) ,

sum(PRODUTO.QATU_REAL * (PRODUTO.B1_PRV1 * ((100 - vDescontoMedioTipo)/100 )))
)

Before selecting the product

After selecting the product

[agigliotti]

maybe this:

=sum(
if( PRODUTO.B1_PRV1 = 0, ( PRODUTO.QATU_REAL * (PRODUTO.B1_UPRCDOL * vFator ) ),
( PRODUTO.QATU_REAL * (PRODUTO.B1_PRV1 * ((100 - vDescontoMedioTipo)/100 )) )
)
)

I hope it can helps.

[fftec_fftec]

Unfortunately it didn't. Do you have any other tips to help me?

[fftec_fftec · Accepted solution]

The problem was in the variable vFator.
Thank you!