getpivotdata formula issue that searches for text with an _

[rory1111]

I have an getpivotdata formula that works quiet well for multiple items but fails to return data for one item. The main difference between the item that fails to return a result and the others is that it contains an Underscore.

=IFERROR(ROUND(GETPIVOTDATA("Events",Changes!$C$503,"Last changed by",$C115,"Week",H$105),5),"")

Entry that fails is : User_One all the others are User2, User3 etc. I think the _ is causing an issue, I've searched this forum and others and also searched google and cant find anything about _ issues with Getpivotdata formula. Has anyone any ideas on bypassing this problem. As i said the formula works fins for all the other users.

 

[RoryA]

Have you verified that C115 actually matches the text that is in the pivot table, using a simple = test?

 

[rory1111]

Have you verified that C115 actually matches the text that is in the pivot table, using a simple = test?

Hi Rory,

The data in C115 matches the text that is in the pivot. I wasn't able to use the = test? that you mentioned but i have checked the text and they are identical (no spaces, case sensitive etc)

Rory

 

[RoryA]

I meant a simple formula like:

=C115=A2

where A2 is the actual cell in the pivot table containing the user name.