restriction between 2 set analysis

[Mahmoud]

Hello,

I want to show only the rows where  "Ventes" = 0 

Expression CA net:  Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)

Expression Ventes:  Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)

Thank you

[sunny_talwar · Accepted solution]

May be this

Expression CA net

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={'AC'},Date={">=$(vDateP1D)<=$(vDateP1F)"}, Typologie ={"NEW"}>} Total_Net_HT)
)

Expression Ventes

If(Sum({<Mouvement_ID={"VC"}>} Total_Net_HT) = 0,
Sum({<Mouvement_ID={"VC"}>} Total_Net_HT)
)

[Mahmoud]

it works, Thank youuu 🙂