Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Calendar Month | Year-Period | Financial Year | Financial Period | Month | Period-Month | Month Index |
Jan-14 | 2014-9 | 2014 | 9 | Jan | 9 - Jan | 24177 |
Feb-14 | 2014-10 | 2014 | 10 | Feb | 10 - Feb | 24178 |
Mar-14 | 2014-11 | 2014 | 11 | Mar | 11 - Mar | 24179 |
Apr-14 | 2014-12 | 2014 | 12 | Apr | 12 - Apr | 24180 |
May-14 | 2015-1 | 2015 | 1 | May | 1 - May | 24181 |
Jun-14 | 2015-2 | 2015 | 2 | Jun | 2 - Jun | 24182 |
Jul-14 | 2015-3 | 2015 | 3 | Jul | 3 - Jul | 24183 |
Aug-14 | 2015-4 | 2015 | 4 | Aug | 4 - Aug | 24184 |
Sep-14 | 2015-5 | 2015 | 5 | Sep | 5 - Sep | 24185 |
Oct-14 | 2015-6 | 2015 | 6 | Oct | 6 - Oct | 24186 |
Nov-14 | 2015-7 | 2015 | 7 | Nov | 7 - Nov | 24187 |
Dec-14 | 2015-8 | 2015 | 8 | Dec | 8 - Dec | 24188 |
Hi
In the table above , I have Calendar Month linked to our financial year and period. The month index is calculated by taken Financial Year x 12 + Financial Period. So for eg, Sept 14 , the month index = (2015 x 12) + 5 = 24185.
In my variable overview , i have created a max (MonthIndex) and called it vMaxMI. In my expression label, if i say =vMaxMI, then the result is 24185. However, if i want to display the Calendar Month (ie Sept 14), I have tried :
if ([Month Index] = vMaxMI, [Calendar Month]) , but this does not work. I have tried several other variations, but still no success.
Please can you help.
Thanks
kind regards
Nayan
Hi Konstantins
I have tried it, but i get a blank result. below is the formula i changed where i added the $ sign.
=if(MonthIndex, $(vMaxMI), [Calendar Month])
kind regards
Nayan
Change vMaxMI to $(vMaxMI) in your expression
Use $(vMaxMI)
Hi Konstantins
I have tried it, but i get a blank result. below is the formula i changed where i added the $ sign.
=if(MonthIndex, $(vMaxMI), [Calendar Month])
kind regards
Nayan
Hi
An error on my side, in the formula, i mistakenly subsituted a 'comma' for the 'equals to' . The formula works
Thank you
kind regards
Nayan