2007 Excel - GETPIVOTDATA

[Elizabeth]

I want to create a formula that should be easy but can't get it to work for
some reason. I have 3 cells within a pivot table that I want to add, then
divide by a different cell. This is what I am trying to use:

=GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New
Business")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business
BOR")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business: one
time revenue for special project")/GETPIVOTDATA("AnnualizedCommission",$A$3)

I get a calculation, but it is wrong. Basically, my answer should be 62%
but I am getting 413%. I've tried every function I can think of - can anyone
help? Thanks!

 

[Glenn]

I want to create a formula that should be easy but can't get it to work for
some reason. I have 3 cells within a pivot table that I want to add, then
divide by a different cell. This is what I am trying to use:

=GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New
Business")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business
BOR")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business: one
time revenue for special project")/GETPIVOTDATA("AnnualizedCommission",$A$3)

I get a calculation, but it is wrong. Basically, my answer should be 62%
but I am getting 413%. I've tried every function I can think of - can anyone
help? Thanks!

Maybe this:

=(GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business BOR")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status",
"New Business: one time revenue for special project"))/
GETPIVOTDATA("AnnualizedCommission",$A$3)

 

[Elizabeth]

Glen, thank you soooo much! That did the trick!

Maybe this:

=(GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business BOR")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status",
"New Business: one time revenue for special project"))/
GETPIVOTDATA("AnnualizedCommission",$A$3)
.