Set Analysis - '}' expected

[#1]

Hello,

I have created the following expression in a textbox:

=max({<Year= {"$(=max({1} Year))"}>Left([ YearMonth],2))

Result:

Error: '}' expected

I already been looking around and I cant spot where the problem is...

Can you give me a hint please!

Thank you!

[#2 · Accepted solution]

=max({<Year= {"$(=max({1} Year))"}>} Left([ YearMonth],2))

=max({<Year= {"$(=max({1} Year))"}> here need } Left([ YearMonth],2))

[Chanty4u]

here

=max({<Year= {"$(=max({1} Year))"}>}Left([ YearMonth],2))

[Anil_Babu_Samineni]

Can you please explain, What do you want to Achieve.

[arulsettu]

try this

max({<Year= {"$(=max({1} Year))"}>}Left([ YearMonth],2))

[boorgura]

=max({<Year= {"$(=max({1} Year))"}>Left([ YearMonth],2))

Why do you have a space within the []  for YearMonth field ??

[saimahasan]

First of all remove the space from [ YearMonth]

Secondly, remove {1}.

Try expression like:

=max({<Year= {"$(=max(Year))"}>}Left(YearMonth,2))

Hope it satisfies your requirement.

[Clever_Anjos]

=max({<Year= {"$(=max({1} Year))"}> } Left([ YearMonth],2))

[#9]

Rodrigo,

Thank you for that, that was what was missing!

[#10]

Thanks all for you help, really appreciate!