Set Analysis Error

[#1]

Hi,

I am trying to calculate and display last date which belongs to previous year in a Textbox by using below formula but getting error, I have implemented variable "Vpreviousyear" at script level for calculating previous year which I am using in formula

Formula : =max({<Year={$(=Vpreviousyear)}>}Claim_Creation_Date)

Error: Error in set modifier adhoc element list ',' or ')' expected

Vpreviousyear: Year(max(addmonths(Claim_Creation_Date,-12)));

[effinty2112 · Accepted solution]

Helo,

          Try:

=max({<Year={$(=-1+Max(Year))}>}Claim_Creation_Date)

Regards

Andrew

[swuehl]

Try

Formula : =max({<Year={$(=$(Vpreviousyear))}>}Claim_Creation_Date)

[Anonymous]

try this?

=max({<Year={$(Vpreviousyear)}>} Claim_Creation_Date)

[susovan]

Try this,

=max({<Year={"$(Vpreviousyear)"}>}Claim_Creation_Date)