set analysis formula works in textobject but not in LOAD SCRIPT

[mark_manalo]

I have the following formula in a Text Object:

    =Num(Sum(Aggr(Count({<Jahr={$(vTodayYear)}, Kw={">=1<=$(vTodayKw)"}, Database.Kennzahl={'Ew'}, Database.Szenario={'Actual'}>} DISTINCT Database.MitarbeiterID), Kw) /  vTodayKw) , '###.##0')

This works and it gives me the desired Value. But when I want to SET it to LOAD SCRIPT like this:

    SET vMyVar = =Num(Sum(Aggr(Count({<Jahr={$(vTodayYear)}, Kw={">=1<=$(vTodayKw)"}, Database.Kennzahl={'Ew'}, Database.Szenario={'Actual'}>} DISTINCT Database.MitarbeiterID), Kw) /  vTodayKw) , '###.##0');

This doesn't work and theres no ErrorMessage

Thanks for any help!

[Anil_Babu_Samineni]

How you are calling in Text object? vMyVar Instead use $(vMyVar)