4 Replies Latest reply: Dec 22, 2015 9:34 AM by Suzan Wijnans RSS

    set variable in script with set analysis

    Suzan Wijnans

      I am trying to put my expression as a variable in my script. With a lot of expressions there is no problem, but this one gives me a headache ;-)

       

      If I use this expression directly in my dashboard all goes well. A nice percentage is calculated.

      =sum({<Jaar = {$(=Max(Jaar)-1)}>} [# Netto Verzuimdagen]) / sum({<Jaar = {$(=Max(Jaar)-1)}>}  [# Dagen Bezetting Netto]);

       

       

      If I put exactly the same text as variable in my script it fails when called.

       

      SET vExp_VerzuimVorigJaar = sum({<Jaar = {$(=Max(Jaar)-1)}>} [# Netto Verzuimdagen]) / sum({<Jaar = {$(=Max(Jaar)-1)}>}  [# Dagen Bezetting Netto]);

       

      Text Box: =$(vExp_VerzuimVorigJaar)

      My result in text box is:

       

       

       

       

      If I leave the '=$' in text box to check my variable it gives the following result.

      Somehow my Function 'Max(Jaar)-1)' is gone.

       

       

       

       

      Please help? Thanks!