2 Replies Latest reply: Apr 8, 2013 6:51 AM by gilles sanchez RSS

    Usage of SetAnalysis

    gilles sanchez

      I am trying to make this statement work

       

      =Max({$<[Calendar Year/Week]=Max(TOTAL [Calendar Year/Week])>}  Aggr( if($(vDE%LAG4BIBA)>1,1,$(vDE%LAG4BIBA)),[Calendar Year/Week],[Commercial Product]))

       

      and it doesn't.

      Can somebody check this statement and tell mme if I am making a typo mistake with >}...

      The statement work when I am writting

       

      =Max({$<[Calendar Year/Week]={201306}>}  Aggr( if($(vDE%LAG4BIBA)>1,1,$(vDE%LAG4BIBA)),[Calendar Year/Week],[Commercial Product]))

       

      and it works when I remove the set analysis from the statement

       

      Thanks in advance for your help

       

      gilles