2 Replies Latest reply: Aug 25, 2011 4:43 PM by Hans kleijnen RSS

    replacing formula by variable does not work

    Hans kleijnen

      When I use this formula in a pivot table it just works fine. For each month I get the correct number.

      =SUM({$<cat2 = {"V01"}>}Debet)-SUM({$<cat2 = {"V01"}>}Credit)

      I want to limit typing, so I defined a variable (ctrl+alt+v) copy/pasting the formule and named the variable "vCalculation" . When using this variable in a pivot table ='$(vCalculation1)', each and every month generates the annual total, the subtotal generated by the pivottable also returns that same annual total. Who can help me?