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.