7 Replies Latest reply: May 3, 2017 7:30 AM by Rob Wunderlich RSS

    expression without dimension

    souad ouertani

      I have a table with the expression test1 and test:

       

      TEST1:

       

      if((sum({<REAL_PACKS.LIB_TYPE_PACK={"SAFIR PRO","ELITE (ex PREMIUM)","PLATINUM","SAFIR","ELITE PRO","PLATINUM PRO"},REAL_PACKS.PROD_PACK={"1"}>}REAL_PACKS.NOMBRE_PACK)

      /

      (sum({<ANNEE_OBJECTIF={$(=Max(YEAR))},MARCHE_OBJECTIF={"PP"},OBJ_PACK.TYPEPACK={"ELITE","PLATINUM","SAFIR","SAFIR PRO"}>}OBJ_PACK.PACK_OBJ/100*60)/6*MAX(MONTHNUM)))*100>200

      ,2,

       

       

      sum({<REAL_PACKS.LIB_TYPE_PACK={"SAFIR PRO","ELITE (ex PREMIUM)","PLATINUM","SAFIR","ELITE PRO","PLATINUM PRO"},REAL_PACKS.PROD_PACK={"1"}>}REAL_PACKS.NOMBRE_PACK)

      /

      (sum({<ANNEE_OBJECTIF={$(=Max(YEAR))},MARCHE_OBJECTIF={"PP"},OBJ_PACK.TYPEPACK={"ELITE","PLATINUM","SAFIR","SAFIR PRO"}>}OBJ_PACK.PACK_OBJ/100*60)/6*MAX(MONTHNUM))

      )

       

      TEST:

      I WANT TEST ELIMINATES THE DIMENSION AGENCY IS TO SAY POSSIBLE EXPRESSION OF ALL AGENCIES

       

       

       

      c1.PNG