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,

      Brian