MTD and YTD Caluclation for Weeeks

Ask a Question

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

0 Replies