1 Reply Latest reply: Jan 31, 2018 7:29 PM by Anil Samineni RSS

    set analysis formula works in textobject but not in LOAD SCRIPT

    Mark Anthony 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!