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" wrote:
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.