no value on set analysis Value equal to 0

[Anonymous]

Hello,

I have a problem on a formula I think it's to values that must be equal to 0. Here are the program and formula.

When I removed the division by the exchange rate it works ...

Formula :

=(sum({<StatusDA = {'B'},EtatTraitementDA={'05'}>}Quantite_Commande) - sum({<StatusDA = {'B'},EtatTraitementDA={'05'}>}QteRecept)) *

(sum({<StatusDA = {'B'},EtatTraitementDA={'05'}>}Prix_Commande / Qte_Prix_Commande)) / TAUX_CHANGE

If i remove / TAUX_CHANGE

Anybody have an idea?

When i developped the tab it works (see the screenshot)

[lironbaram · Accepted solution]

hi

your problem is that in jun-2015 you have two values in the field TAUX_CHANGE

so when you look at it in the expended view each row has one value

but when you look at it in the collapsed view qlikview doesn't know which value to use for the calculation

attached is the model fixed

[Anonymous]

Thank you very much !!