4 Replies Latest reply: Sep 21, 2016 7:06 PM by Mark Van Der Berg RSS

    Using Multiple variables in a Set Analysis

    Mark Van Der Berg

      I am comparing an avg value over a period, to the period prior to it to determine if the change is +/-.

      Now I would like to substitute the defined period with variables. Unfortunately I am having no luck.

      Current expression:

      =if(avg({$<CDIMonthID={">$(=max(CDIMonthID)- 6) ,<=$(=max(CDIMonthID))"}>}CDI)

        >

        avg({$<CDIMonthID={">$(=max(CDIMonthID)-12) ,<=$(=max(CDIMonthID)-6)"}>}CDI),

        'qmem://<bundled>/BuiltIn/arrow_n_r.png',

        'qmem://<bundled>/BuiltIn/arrow_s_g.png')

       

      Proposed expression (which is not working)

      =if(avg({$<CDIMonthID={">$(=max(CDIMonthID)- $(vCDIPeriod)) ,<=$(=max(CDIMonthID))"}>}CDI)

        >

        avg({$<CDIMonthID={">$(=max(CDIMonthID)-($(vCDIPeriod)*'2')) ,<=$(=max(CDIMonthID)-$(vCDIPeriod))"}>}CDI),

        'qmem://<bundled>/BuiltIn/arrow_n_r.png',

        'qmem://<bundled>/BuiltIn/arrow_s_g.png')

       

      I have tried different syntax and values to no avail.

       

      (My first question posted on this forum, after finding the answers to my previous questions in other posts)