Simple issue with set analysis

[#1]

sum({$<LinkYear3={$(=$(vCurrentFiscalYear))}

right(LinkMonth3,3)={$(=$(vCurrentFiscalMonth))}

>}ATD)

In the set analysis above, I get the appropriate answer when I don't include the middlle month line, but I don't get any value when I include it.  For some reason it doesn't work even thought they both have the 3 letter capitalized abbreviation for month for the variable and the right trimmed field. 

[CELAMBARASAN · Accepted solution]

Hi,

     Your not allowed to use right(LinkMonth3,3) as a fieldname to compare in set analysis.

To solve you problem go with wildcard match like below

sum({$<LinkYear3={$(=$(vCurrentFiscalYear))}

LinkMonth3={"*$(vCurrentFiscalMonth)"}

>}ATD)

here * is used for zero or more chars before it.