Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!
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!
YES!!
Thank you Gabriela, that did the trick.
bst rgrds
Hans