How to do month to date(MTD) calculation in a module

Singh_Rahul

Accepted answers

anand.shekhawat

@Singh_Rahul

Its not MTD. It would be YTD

Refer the below screenshot for your reference

~Anand

All comments

anand.shekhawat

@Singh_Rahul

MONTHTODATE returns a cumulative sums across a month time span for a single numeric parameter then resets it value . The syntax is MONTHTODATE(x) .Below shows the application of MONTHTODATE function

When you observe clearly you can see that sum of Sales for week 1 and week 2 is equal to Monthvalue of week 2 , similarly sum of week 1, week 2, week 3 and week 4 is equal to Monthvalue in Week 4.

Now observe the value resets in Week 5 and starts calculating again for that particular month.

Also make sure that the time should be either in days or weeks, and the formula cannot be used, if model timescale is General Weeks.

(Correction: the line item says Monthvalue , but it's MONTHTODATE)

I hope it helps

~Anand

Singh_Rahul

@anand.shekhawat thank you for the detailed answer.

So for below example Monthvalue(Sales) should be 1600 correct ?

Rahul

anand.shekhawat

@Singh_Rahul

No, the MONTHVALUE(Sales) would return 260 for week 1-4 , 420 for week 5-8 and so on. It actually gives the month summary value as the output. Refer the below screenshot

I hope it helps

~Anand

Singh_Rahul

Ok.

@anand.shekhawat So let me put my question in the other way.

Let say the time scale is month(Jan'21,Feb'21...) and sales(100,200...likewise) so my expected output for MTD should be 300. So how to get that output.

Rahul

anand.shekhawat

@Singh_Rahul

Its not MTD. It would be YTD

Refer the below screenshot for your reference

~Anand

Quick Links

Can you help?

Unanswered questions

FCR: Intercompany Matching Report Not Reflecting Results
We would like to ask about an issue with the Intercompany Matching Report. We have executed intercompany matching; however, the results are not being reflected correctly in the report. We have outlined the steps we implemented below and would appreciate it if you could advise whether anything is missing or incorrect in our…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…