replacing formula by variable does not work

[qlikhans]

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?

[#2 · Accepted solution]

Hi,

When you define your variable don't put the '=' symbol, so the expression in your varible should be: SUM({$<cat2 = {"V01"}>}Debet)-SUM({$<cat2 = {"V01"}>}Credit) without the '=' and in your object put $(vCalculation) inside the expression

Hope this helps

Regards!

[qlikhans]

YES!!

Thank you Gabriela, that did the trick.

bst rgrds

Hans