1 Reply Latest reply: Apr 16, 2018 11:17 AM by surya j RSS

    Wanted to bind the user input date in formula

    surya j

      Hi

       

      Now my formula is binding the last week end date instead of that i wanted to bind the user selected week end date.

       

      =Sum({1<[PROCESSED_DT.autoCalendar.Date]={">=$(=(MonthStart(Max({1}[PROCESSED_DT.autoCalendar.Date]))))<=$(=WeekEnd(Max({1}[PROCESSED_DT.autoCalendar.Date]),-1))"},

      [Rollover_Activity_Only.ROLLOVER_DESTINATION_TXT]={'RTF'}

      >}

      [Rollover_Activity_Only.ROLLED_TO_AMT])/1000000

       

      Is that possible?