Pivot table - measure or calculated field - IF formula

[Angeljurich15]

*I attached a picture for reference*

I have a pivot table. I tried using a calculated field and also a measure for an IF formula.

I want: If, in the 'License/Certification' field, it says "DCFS BCU - 142395", then to put a 1, if not, then put a zero

The formula I used was : =if([License/Certification]="DCFS BCU - 142395",1,0)

It doesn't work. I have tried it several ways with no success.

**I want it as a calculated field because I have to use that number result for additional formulas.

 

[BigBeachBananas]

I think it's because calculated field lists are aggregate functions (e.g., sum, average, etc....), so it doesn't work for logic. It needs to be calculated values.