Pivot Calculated Field -If Statments
 

Hello,

I know 'If' statments can be used in Calculated Fields of pivot tables where
the result is a number. However is there a way the result can be text? e.g.
if(x.15,"Fail","Pass")

Thanks!

Pivot Calculated Field -If Statments
 

It depends what x is, but maybe you could use a custom number format for
the data field.
Double-click on the field button, and click the Number button
For Category, choose Custom
In the Text box, type:
[.15]"Fail";[<=.15]"Pass";General

David127 wrote:
I know 'If' statments can be used in Calculated Fields of pivot tables where
the result is a number. However is there a way the result can be text? e.g.
if(x.15,"Fail","Pass")


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

Pivot Calculated Field -If Statments
 

Hi Debra - This worked great. Thanks!

"Debra Dalgleish" wrote:

It depends what x is, but maybe you could use a custom number format for
the data field.
Double-click on the field button, and click the Number button
For Category, choose Custom
In the Text box, type:
[.15]"Fail";[<=.15]"Pass";General

David127 wrote:
I know 'If' statments can be used in Calculated Fields of pivot tables where
the result is a number. However is there a way the result can be text? e.g.
if(x.15,"Fail","Pass")


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