1 Reply Latest reply: Apr 28, 2016 6:23 AM by Sunny Talwar RSS

    Alternative state

    Hasvine Dhurmea

      Hello All,

       

      I have a table which is in State A:

       

      QuestionNoteTestCumulative 2016
      QA125.5%32.0%45%

       

      I have current selection of Month and Make for this state.

       

      However, I want that the cummulative 2016 to bypass the state and cummulate the results of this current year.

       

      I am using the expression below for the cummulative but the result is wrong:

       

      =Sum({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)/Count({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)

       

      Any idea?

       

      Many Thanks,

       

      Hasvine