topic Dynamic MTD cacl in App Development

Dynamic MTD cacl

Anonymous — Sun, 15 Apr 2018 17:47:50 GMT

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

Re: Dynamic MTD cacl

rachel_delany — Mon, 16 Apr 2018 01:19:35 GMT

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.

Re: Dynamic MTD cacl

Anonymous — Mon, 16 Apr 2018 13:01:28 GMT

below mentioned is the expression

Let vMonth=Month(Today());

Re: Dynamic MTD cacl

Anonymous — Mon, 16 Apr 2018 15:16:49 GMT

Hi Guys,

Any suggestion?

Re: Dynamic MTD cacl

rachel_delany — Mon, 16 Apr 2018 23:37:45 GMT

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.