Angeljurich15
New Member
- Joined
- Jan 23, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
*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.
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.