MonthName in set anaylsis

[tschullo]

I have the following script:

Load
MonthName(monYr) as MonYr,
myVal;

Load * Inline [
monYr, myVal
41760, 1
41791, 2
]

I then have a variable vMaxMonYr defined as:

=Max(MonYr)

then have a text box:

Script:

=$(vMaxMonYr) & '
MaxVal: ' & sum({<MonYr={"MonthName($(vMaxMonYr)"}>} myVal)

The result I get is:

41791

MaxVal=0

If I change the script to:

=$(vMaxMonYr) & '
MaxVal: ' & sum({<MonYr={'Jun 2014'}>} myVal)

it works ands I get:

41791

MaxVal=2

Why is that  and how can I write script so it works?

[tschullo]

Nice! Thanks a lot!

[sunny_talwar]

Awesome

I am glad I was able to help. I would suggest marking any helpful answers (if you think there are any ) this way it can help people to spot some helpful answers in the future.

Best,

Sunny