Combine IFERROR with OR statement

[Haneyg]

Hello,

I am trying to combine an IFERROR statement with an OR condition. The data I am pulling from is a Pivot table, and I've figured out how to eliminate the errors when no relevant pivot row is available, but I also need to change any 0 values returned to a text format hyphen "-" for visual readability.

Current formula:

=IFERROR(GETPIVOTDATA("ID",Pivots!$B$32,"MONTH",7,"YEAR",2017,"Team","AES"),"-")

This returns correct values, but I also want to turn any 0 numeric result into a text "-" so errors and zero values would both return "-". Thoughts for solution?

Here is a visual of what I am seeing, and want to turn the zeros into hyphens: https://pasteboard.co/H7Xr0Pm.png

 

[Haneyg]

Solved:

Took me another hour, but I found a solution. Couldn't figure out how to use OR correctly, so I nested two IFERROR statements within a parent IF statement for the zero values. There's likely an easier way, because this is ugly:

=IF((IFERROR(GETPIVOTDATA("ID",Pivots!$B$32,"MONTH",7,"YEAR",2017,"Team","AES"),"-"))=0,"-",(IFERROR(GETPIVOTDATA("ID",Pivots!$B$32,"MONTH",7,"YEAR",2017,"Team","AES"),"-")))