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

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

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

On Aug 3, 9:22 pm, "G Lykos" wrote:
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,"")

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

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

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

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

G Lykos wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

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


"AndrewArmstrong" wrote in message
oups.com...
That's a double quote, it may be hard to see

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

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" wrote in message
...
No, a calculated field can't return a null or a blank cell.

G Lykos wrote:
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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

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

G Lykos wrote:
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" wrote in message
...

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

G Lykos wrote:

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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html