3 Replies Latest reply: Feb 10, 2010 12:25 PM by Rupert Cavendish RSS

    Date Range with Set Analysis

    Rupert Cavendish

      I seem to have hit a brick wall with this one. I have looked at a whole series of posts - none of which seem to assist.

      I have a simple problem in that i wish to retrieve sum between 2 dates in the following expression:

      Sum( {$<TIME_DATE = {"<$(weekstart(today(1))) >=$(yearstart(today(1)))"}>} REVENUE )

      where the result is needed for the 1st day of the year through to the last day of last week (as we are always looking retrospectively 1 week in arrears).