2 Replies Latest reply: Apr 26, 2013 11:29 AM by Brian Garside RSS

    Need help with Set Analysis Dynamic Date

      I have two basic date based set analysis summations. One works (bottom) the top one does not.

      The dynamic date generates the same date 04/01/2013 when I place it in a text box for testing.

       

      Not sure why it still sums up all months regardless. No errors, but wrong summation.

       

      Dynamic still sums up all months;

      =Sum({$<RevMonth={'=Date(MonthStart(Today(2)))'}>} RevAmt)

       

      Works for April 2013 perfectly for this date: 04/01/2013

      =Sum({$<RevMonth={'04/01/2013'}>} RevAmt)