Forum Discussion
GET PIVOTDATA #REF! error
Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")
Depends on what's in T8. If that value isn't in the pivottable #REF! is the result. Please note that you might need to convert the content of T8 to text:
=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")
- Hi Jan, I have a similar question except instead of returning a text value, I need to return a blank field from the pivot table as a number. The pivot table contains information about sales by each salesperson. Since some of the salespeople are new, there is blank (null?) data in some of the months and when I try to reference the sum of that particular month in my calculation, it returns an #REF! error. The formula is =GETPIVOTDATA("Total Ext. Price",$A$3,"SO Month",1). I've made sure the pivot table number format is a number.
Thanks Jan for your quick response. Converting to text, based on your syntax worked, but please educated me on "how" this works. I understand the concatenate function with the & symbol, but I don't understand how the syntax for this statement works.
This worked! Look forward to your response.
- Adding an empty string to a number converts that number to a string value.
Good to know! Thanks!
