Dynamic variable not working in expression

[Anonymous]

I have created a variable to get the maximum month of all the selected month.

Variable Name : Max Month

Definition : SubField(GetFieldSelections([Month],',',GetSelectedCount([Month])),',',GetSelectedCount([Month]))

I am trying to use it in a sum function but its not working. Looks like some syntax error.

Please help.

Thing I have tried

=sum({$<Geo={"EUZ"} , Month={$(Max Month)}>} Actual)  --- Error

=sum({$<Geo={"EUZ"} , Month={'$(Max Month)'}>} Actual)  ---- Giving 0 which is not the write answer

=sum({$<Geo={"EUZ"} , Month={$(=Max Month)}>}Actual1) --- Again giving 0

[tamilarasu · Accepted solution]

Hi Anvita,

Try this expression

=sum({$<Geo={"EUZ"} , Month={"$(=$(Max Month))"}>}Actual1)

Or

Add equal sign in the variable definition and try,

=SubField(GetFieldSelections([Month],',',GetSelectedCount([Month])),',',GetSelectedCount([Month]))

[vinieme12]

Isn't Max (Getfieldselections ([Month])) working ?

May be even Max ([Month])

Why are you using subfield??

[Frank_Hartmann]

perhaps this:

=sum({$<Geo={"EUZ"} , Month={'=$(=Max Month)'}>}Actual1)

[Anonymous]

Thanks Tamil Nagaraj !! 

The expression you have given works nicely !

[Anonymous]

Thanks everyone for your inputs. Much appreciated.