Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate number of months in a Fiscal year based on the start date and the End date.
EX: fISCAL YR IS FROM July- June
Start Date | End DATE |
3/1/2018 0:00 | 10/31/2018 23:59 |
11/1/2018 0:00 | 10/31/2019 23:59 |
11/1/2019 0:00 | 10/31/2020 23:59 |
1st row has 4 months, 2nd row has 8 Months and that's for 2019
2nd row has 4 months and 3rd row has 8 months and that's for 2020.
Best I have is the following Design Blog post that may provide some ideas for you on how to approach things:
https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103
Regards,
Brett