6 Replies Latest reply: Apr 29, 2013 2:46 PM by Kaushik Solanki RSS

    User Date selections for Set Analysis not adequate..need help

      I have a Set Analysis expression that works great under strict circumstances.


      This sums up a Date Range from Min to the Max Months selected. or Max(RevMonth)


      Sum({$<RevMonth={"$(='>=' & Min({$} RevMonth) & '<=' & AddMonths(Min(RevMonth),MonthDiff) )"}>} RevAmt



      The problem is if a user selects Non Consecutive months then the calculation is wrong or sums up to much because it does not take into account the 'missing' months.  Is there a better way to handle this situation.?  What I'm I doing wrong ?


      Thank You all,