Forum Discussion

Gingerjeans88's avatar
Gingerjeans88
Icon for Helper IV rankHelper IV
5 years ago

Custom Fiscal Year and YoY by Fiscal Week - Help!

Hi!    A couple of things I'd be so grateful for help with I have a report based on Dynamics CRM data for a school - I need to be able to show number of Applications made by fiscal year  - the yea...
Need Help
Gingerjeans88's avatar
Gingerjeans88
Icon for Helper IV rankHelper IV
5 years ago

Hi Amit,

 

Thanks so much for your reply - however, your calculations for the custom date table are not quite what I need. They are really useful if the start of my financial year was the first day of a month, but it's more variable than that. The first day of the financial (academic year) is the beginning (monday) of the third week in September. How would I account for this as the actual date will be different every year?

Gingerjeans88's avatar
Gingerjeans88
Icon for Helper IV rankHelper IV
5 years ago

Any update amitchandak ? Or does anybody else have any helpful tips?