Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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) )
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) )
it works, Thank youuu 🙂