Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wanted to bind the user input date in formula

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?

1 Reply
Anonymous
Not applicable
Author

Hi

Any suggestion ?