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 = =






      In my text box I have




      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.