Adding formula in Pivot table

[Ecel Dumbo]

Hello ,


I had added the below formula

=IF(ISERROR(' Netinv.sls'/Netinv.qty),"",' Netinv.sls'/Netinv.qty)


in to the caculated field for a pivot table. Where there are no values for Net inv.sls and Net inv.qty columns of the pivot table, the result for the above formula appears as #Value!. How can I get rid of this to be make it appear blank ?


Thanks

 

[DJ]

In this case, please check your data. Surely there are non-numeric values exist in "Netinv.sls" or "Netinv.qty" columns.