Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
How you are calling in Text object? vMyVar Instead use $(vMyVar)