11 Replies Latest reply: Mar 28, 2018 4:46 AM by Sunny Talwar RSS

    Dynamic Set Analysis

    Chiara Pannese

      Hi All,

      i've an issue with Set Analysis.

      I have to calculate a Cumulative measure but i cannot use above function because it doesn't work correctly for me when i make selections.

      The reference measure is

       

      Sum( {$< MonthDiff={'-1'} >} #MEASURE)

       

      i'm trying to use this formula for having cumulate:

       

      Sum( {$< MonthDiff={'-1'} >} #MEASURE)  +

      Sum({$<MonthDiff={">=0 <=$(=num(Month(AsOfMonth))-2)"}  #MEASURE)


      The problem is that the string    <=$(=num(Month(AsOfMonth))-2)    doesn't work.

      How can i write this for Set Analysis?


      Thank you All.