1 Reply Latest reply: Oct 3, 2017 9:11 PM by Sunny Talwar RSS

    Calculation going back 30 days in straight table

    gerry castellino

      I have a straight table,  it doesn;t have a date dimension.

       

      I'm trying in my expression calculation go back 30 days from the date selected in the dimension filter.

       

      By doing this:

       

      sum({<Activity_Date = {"$(=Date(AddMonths(Only({$} Activity_Date), -1), 'MM/DD/YYYY'))"}  >} SENT_TO_CARRIER_COUNT_UNLAGGED)

       

      What am I doing wrong.