<div>
You want to put a formula in your query that states if zero is the outcome replace the zero with null.
</div>


You want to put a formula in your query that states if zero is the outcome replace the zero with null.

<div>
Sorry for taking so long - <br />
<br />
This was far too easy!<br />
<br />
Thanks!
</div>


Sorry for taking so long -

This was far too easy!

Thanks!

<div>
<div class="content wysiwyg-content">
Hello Experts!<br />
<br />
I have a pivot table query which contains calculated total fields. &nbsp;These calculated fields default to zero if the calculation cannot be performed (due to division by zero, etc).<br />
<br />
Currently, all fields (row fields) are visible - even those with a calculated value of zero. &nbsp;However, I would like to hide these.<br />
<br />
Is there a setting I'm missing? &nbsp;Should I change my formula to default to null? &nbsp;Ideas?<br />
<br />

</div>
</div>


Hello Experts!

I have a pivot table query which contains calculated total fields.  These calculated fields default to zero if the calculation cannot be performed (due to division by zero, etc).

Currently, all fields (row fields) are visible - even those with a calculated value of zero.  However, I would like to hide these.

Is there a setting I'm missing?  Should I change my formula to default to null?  Ideas?



Pivot Table - Hide Calculated Zero Fields

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.