4 Replies Latest reply: Sep 1, 2011 1:05 PM by Hans kleijnen RSS

    using variable in formula

    Hans kleijnen

      Hi,

      I have defined a variable vGL_mutatie as sum({$}Debet)-sum({$}Credit). In a pivot table =$(vGL_mutatie) works. Now I want to apply this variable to the formula sum(if (InYear (Boekdatum, Today(), -1), Debet))-sum(if (InYear (Boekdatum, Today(), -1), Credit)).

       

      I tried several varaties, such as :

      if (InYear (Boekdatum, Today(), -1, $(vGL_mutatie)))

      sum(if (InYear (Boekdatum, Today(), -1, vGL_mutatie)))

       

      who helps me out?

       

      kind regards

      Hans