Replace #REF! with 0

[pmviana]

I am using the following formula to get the quantities of the blue model if found in a pivot table(=+GETPIVOTDATA("Sales";'2019'!$A$3;"Model";"Blue").
When is not on the list I get "#REF!", how can I have "0" instead?
Many thanks in advance.

 

[AngelinaT]

try =iferror(your formula here,0) around your formula

 

[pmviana]

try =iferror(your formula here,0) around your formula

I must be doing something wrong as it cames back an error. I am using the following formula =IFERROR(+GETPIVOTDATA("Sales";'2019'!$A$3;"Model";"Blue"),0)...

 

[AngelinaT]

can you try =IFERROR((+GETPIVOTDATA("Sales";'2019'!$A$3;"Model";"Blue"),0)