#DIV/0! in PivotTable

[StephanieH]

I have a basic calculated field in my Pivot Table = Bal\Num. I get a Div
when the Bal and Num are empty. How can I write an IF statement so that the
field remains blank if the Num is empty?

A regular formula like
If(Bal="","",Bal/Num) would normally work.

 

[Max]

Untested, but maybe you could try right-click in pivot > Table Options
There's an setting there which reads:
For error values, show: (leave blank)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[StephanieH]

Worked like a charm. Thanks Max

Untested, but maybe you could try right-click in pivot > Table Options
There's an setting there which reads:
For error values, show: (leave blank)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Max]

Welcome. Pl press the YES button (like the one below) in that response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik