5 Replies Latest reply: Dec 10, 2013 3:18 PM by Kevin Bertsch RSS

    Set-analysis - selecting the last 7 days and all days in  a month

      Hi,

       

      I am trying to have a textbox which will show me a summary, regarding of the selection, of a value (revenue).

      So I need:

      1) Revenue Last 7 days (including weekends and crossing back to previous month if needed.

      2) Revenue month-to-date - all days in the current month-year pair - till today.

       

      For the LAST-7-Days:

      I have "timestamp" and also DateMonth, DateYear, DateDay.

       

      I tried the "bookmark" approach, creating a listbox, and setting the query, and then saving the BookMark.

      =if(DateTime>=now()-8,if(DateTime<now()-1,DateTime

       

      The I use it in the textbox: =sum({BM_Last_7_Days}revenue)

       

      But the problem is that when there are other selections active, it's not working

       

      For the month-to-date:

      I just used

      =DateMonth=$(=Max(DateMonth))

       

      But that's really a bad implementation. It doesn't work across years (like today

       

      Would appriciate any help,

       

      Thanks