Solved Pivot Table error... (1 Viewer)

Number11

Member
Local time
Today, 08:52
Joined
Jan 29, 2020
Messages
607
I am getting the results within a table as "#REF!" as the item its looking for is not presewnt in the pivot table, so i was wondering how can I change this to if not found show as 0

=GETPIVOTDATA("Job Type",$P$28,"Booking Status","Booked")
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:52
Joined
May 7, 2009
Messages
19,170
can you use IFError() function?
 

Number11

Member
Local time
Today, 08:52
Joined
Jan 29, 2020
Messages
607
can you use IFError() function?
Sorry my original error, #REF! not ERROR, so if the pivot has an item as Booked the table works, but if no items then i get the Error ~REF!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:52
Joined
May 7, 2009
Messages
19,170
you test it first, before anything:

=IFERROR(GETPIVOTDATA("Job Type",$P$28,"Booking Status","Booked"), 0)
 

Users who are viewing this thread

Top Bottom