
Contributor II
2021-02-18
12:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MTD and YTD Caluclation for Weeeks
Hi All,
I have a situation where i need to calculate MTD and YTD based on weeks. I'm using Fiscal Calendar and my weeks are also
created based on date ranges.
W1,W2,W3,W4,W5 are calculated as Sales/Qty.
Based on the week values , i have to go with creating MTD for that Month and for subsequent months too and finally YTD from Apr to till date.
Please find the screenshot for the same.
Any example code snippet or links would be a great help.
Regards,
Srinivas K
396 Views
0 Replies
