32 Replies Latest reply: Nov 9, 2017 2:44 AM by Rido Trader RSS

    Variable in Set Analysis

    Rido Trader

      Hi There

       

      I am trying to calculate a percentage out of two formulas, The set analysis doesn't seem to be working with the variable please assist.

       

      vMTDCALC = =


      (
      Sum({<Survey={'Survey1'}>}Excellent)/(Sum({<Survey={'Survey1'}>}Poor)+Sum({<Survey={'Survey1'}>}Average)+Sum({<Survey={'Survey1'}>}Excellent))*0.70

      +

      Sum({<Survey={'Survey2'}>}Excellent)/(Sum({<Survey={'Survey2'}>}Poor)+Sum({<Survey={'Survey2'}>}Average)+Sum({<Survey={'Survey2'}>}Excellent))*0.30)

       

       

      In my text box I have

       

      =Sum({<FIN_YR_MTH_NO={$(vMaxFinYrMthNo)}>}$(vMTDCALC))

       

      The Calculation of sum(vMTDCALC) works but it seems to be ignoring my set analysis... it doesn't look at the max year at all, do I need to some how use the Aggrr function?

       

      Your assistance is appreciated.