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

    using variable in formula

    Hans kleijnen


      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