0 Replies Latest reply on Aug 9, 2013 6:11 PM by Joshua Grossman

    max date sum revenue

    Joshua Grossman

      Hello,

       

      I would like to sum revenue only for the last date in the database.  This is what I tried but with no luck:

       

      IF [Date] = MAX([Date])

      THEN

      SUM([Revenue)

      ELSE 0

      END

       

      I want to show aggregate revenue (which is already done), directly next to today's revenue.

       

      Thanks for your help!

       

      JG