If I understand what you say then the problem will be resolved if you add a financial year field to your calendar. Try something like this in your calendar script:
if (Ceil(Month(Date) / 3)=1,
Year(Date)-1 & '/' & Year(Date),
Year(Date) & '/' & Text(Year(Date)+1) )
I'm assuming that your financial year will run from 1st Apr.
Hope this helps
Thanks for your reply, really appreciate the help.
In an ideal world i would just code in:
Of course it could be that I've missed something. It wouldn't be the first time.
Re your last post:
But when I select a FY and a Period I obtain values that are not correct.
So when working correctly it resembles this:
And when not working correctly it resembles this:
Hopefully these Images better explain my problem. Also to remind my current expression is:
Thanks again Andrew!