Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
exp1:
=sum(if(REAL_PACKS.LIB_TYPE_PACK=OBJ_PACK.TYPEPACK and REAL_PACKS.PROD_PACK=1,REAL_PACKS.NOMBRE_PACK))
for exp i want to calculated cumulative Nombre pack, i use this exp
exp2:
=sum({<OBJ_PACK.TYPEPACK={REAL_PACKS.LIB_TYPE_PACK} , REAL_PACKS.PROD_PACK={"1"},YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,SITUATION_PRODUIT>} REAL_PACKS.NOMBRE_PACK)
this exp shows 0,
and when i remove OBJ_PACK.TYPEPACK={REAL_PACKS.LIB_TYPE_PACK}
this exp shows result but it's not correct
What if you do this
=Sum({<REAL_PACKS.PROD_PACK = {1}, YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} , SITUATION_PRODUIT>} If(OBJ_PACK.TYPEPACK = REAL_PACKS.LIB_TYPE_PACK, REAL_PACKS.NOMBRE_PACK))
What if you do this
=Sum({<REAL_PACKS.PROD_PACK = {1}, YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} , SITUATION_PRODUIT>} If(OBJ_PACK.TYPEPACK = REAL_PACKS.LIB_TYPE_PACK, REAL_PACKS.NOMBRE_PACK))
hahah thank you sunny