PivotTable Custom Field - formula for no value, with blank cell displayed?

[G Lykos]

Greetings! Have created a custom field in a pivottable whose zeros are
configured to be displayed as blank cells. The custom field uses an
=IF(A,B,C) formula. If I don't define C, then the cell appears to be
populated with zero, and displays as such in spite of the pivottable
setting.

Question: is there some function, or constant, that can be used in C such
that there is no value applied to that cell from the formula and it displays
as a blank, not a zero? Empty() and Null() don't work.

Played with this a little, determined that I can apply a custom display
format to the field where zero's aren't displayed, but would like to handle
this via a persistent formula rather than a back-end display format.

Thanks for any ideas!
George

 

[AndrewArmstrong]

Greetings! Have created a custom field in a pivottable whose zeros are
configured to be displayed as blank cells. The custom field uses an
=IF(A,B,C) formula. If I don't define C, then the cell appears to be
populated with zero, and displays as such in spite of the pivottable
setting.

Question: is there some function, or constant, that can be used in C such
that there is no value applied to that cell from the formula and it displays
as a blank, not a zero? Empty() and Null() don't work.

Played with this a little, determined that I can apply a custom display
format to the field where zero's aren't displayed, but would like to handle
this via a persistent formula rather than a back-end display format.

Thanks for any ideas!
George

If(A,B,"")

 

[AndrewArmstrong]

That's a double quote, it may be hard to see

 

[Debra Dalgleish]

No, a calculated field can't return a null or a blank cell.

 

[G Lykos]

Thanks. Believe I tried this, and it resulted in a #VALUE error.

 

[G Lykos]

Okay. Is it then a bug that a zero in a calculated field displays as zero
with General format applied in spite of the pivottable being configured such
that cells with a zero display as blank?

 

[Debra Dalgleish]

How did you configure it? What is the formula for the calculated field?