2 Replies Latest reply: Apr 7, 2017 9:12 AM by souad ouertani RSS

    set analysis with expression

    souad ouertani

      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