@Singh_Rahul
Its not MTD. It would be YTD
Refer the below screenshot for your reference
~Anand
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.shekhawat thank you for the detailed answer.
So for below example Monthvalue(Sales) should be 1600 correct ?
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
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.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
