Relative % in Pivot Table

jdmarlin — Fri, 02 Oct 2015 15:57:08 GMT

I'm trying to get a relative % in a pivot table, but the following formula doesn't work:

-Sum({$<YEAR={$(=vYear)}, MONTH={$(=vMonth)}>} If(ACCTNUM=SUBACCT,ACTIVITY * PERCENTAGE/100))

-Sum(TOTAL {$<YEAR={$(=vYear)}, MONTH={$(=vMonth)}>} If(ACCTNUM=SUBACCT,ACTIVITY * PERCENTAGE/100))

It gives me the same results this formula, which ignores the set analysis:

-Sum(TOTAL If(ACCTNUM=SUBACCT,ACTIVITY * PERCENTAGE/100))

Re: Relative % in Pivot Table

jdmarlin — Fri, 02 Oct 2015 16:55:56 GMT

Not sure what's happening but I've added set modifiers and the total divisor is being calculated properly now:

-Sum({$<YEAR={$(=vYear)}, MONTH={$(=vMonth)}>} If(ACCTNUM=SUBACCT,ACTIVITY * PERCENTAGE/100))

-Sum(TOTAL <ACCTNUM, SUBACCT> {$<YEAR={$(=vYear)}, MONTH={$(=vMonth)}>} If(ACCTNUM=SUBACCT,ACTIVITY * PERCENTAGE/100))