Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible to find a solution to make to do a rangeavg loke this :
=rangeavg(sum({<ABR_MAGASIN={"DJ"} >} if (QUANTITE <> 0,QUANTITE )),sum({<ABR_MAGASIN={"DU"} >} if (QUANTITE <> 0,QUANTITE )),sum({<ABR_MAGASIN={"DL"} >} if (QUANTITE <> 0,QUANTITE )),sum({<ABR_MAGASIN={"LU"} >} if (QUANTITE <> 0,QUANTITE )),sum({<ABR_MAGASIN={"SO"} >} if (QUANTITE <> 0,QUANTITE )))
ABR_MAGASIN it's market for me and i want to find the avg of quantite per market place.
Thanks for your help.