Dynamic MTD cacl

[Anonymous]

Hi

I have weekly report in which one of the calculated field i have monthtodate & networking days.

I have a filter which has the weekend dates listed. If the user looks for the previous month week info the calculated field is taking the current month to date count(Below mentioned is the formula which i used).But that is wrong.

So is it possible to make Month to Date variable to behave dynamically depends on the selected week in the filter?

Formula:

=(Sum({<[Processed_Date.autoCalendar.Month]={'$(vMonth)'},[Seg - Roll]={'Total RTF'}>}

Rolled_To_Amount_Plan))/Monthtodate*Netwrkngdaysinamonth

[rachel_delany]

Can you share the expression you are using to set the vMonth variable?

If you make this variable dynamic so that it is the month of the maximum date (which will take into account a filter) this may solve your problem.

[Anonymous]

below mentioned is the expression

Let vMonth=Month(Today());

[Anonymous]

Hi Guys,

Any suggestion?

[rachel_delany]

Try changing it to:

vMonth=Month(Max(Processed_Date));

Or change Processed_date to whatever the date field is that the user will be selecting.