ISERROR formula in Pivot Table

[janmack79]

I am trying to do a calculated filed in a pivot table but get an error when I entered the below, I am always unsure how many and where I need to put the closed brackets. I would appreciate if anyone could tell me what I have entered below in the formula

=IF(ISERROR('Won Total' +'Pipeline Total') /QuotaAmount ),0,('Won Total' +'Pipeline Total') /QuotaAmount ))

[Mvaldesi]

Looks like you had a couple parenthesis in the wrong places; see if this works for you:

=IF(ISERROR(('Won Total' +'Pipeline Total')/QuotaAmount),0,('Won Total' +'Pipeline Total')/QuotaAmount)

[janmack79]

Ahhh excellent thank you, that works!!

[Mvaldesi]

Glad to help! If your issue is resolved, can you please mark the thread as SOLVED?