Hello Everybody!
I have a field containing Active Duty status (AD, non-AD) and want to create fields that pull only the AD and non-AD. I was thinking of creating a calculated field using the formula below but it's not working. Any ideas as to what I'm doing wrong?
if { FIXED [Limdu Status]: [Bencat]}="AD" then "TRUE" ELSE "FALSE" end
3 risposte
@Brian Adams
If your data is like this
NAME STATUS
Charles AD
Bertram Non-AD
then there is no need to split it.
See attached workbook for your reference.
