Expression Label not displaying correctly

[#1]

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

[Anonymous]

Change vMaxMI to $(vMaxMI) in your expression

[senpradip007]

Use $(vMaxMI)

[#4 · Accepted solution]

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

[#5]

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