pROBLEM WITH SET ANALYSIS SYNTAX

[helen_pip]

Dear all

Could someone kindly help me rewrite the following syntax for the expression below as it is getting an error..  I am unsure what I have done wrong

The variable golds the maximum MonthYear

=Count({<MonthYear ={$(v_Max_MonthYear)}>}OP_Atd_ID)

Kind Regards

Helen

[MK_QSL]

=Count({<MonthYear ={'$(v_Max_MonthYear)'}>}OP_Atd_ID)

What is the result of v_Max_MonthYear?

Also the format of MonthYear and v_Max_MonthYear must be same.

[sunny_talwar · Accepted solution]

What is the format for MonthYear? Does v_Max_MonthYear gives you the output in correct format?

=Count({<MonthYear ={"$(=$(v_Max_MonthYear))"}>}OP_Atd_ID)

or

=Count({<MonthYear ={"$(=v_Max_MonthYear)"}>}OP_Atd_ID)

[helen_pip]

Thank you Sunny

Your formula is working for me.  I also ensured that the variable and Field are in the same format

Kind Regards

Helen