Hi all
Can anyone tell me why this formula is not working or what I am doing wrong? There are plenty of Nurse Practitioners in my data but it doesn't post the 0.85, it just posts 1.
Mid-Level: IIf([PerfProvType]="[Nurse Practitioner]" Or [PerfProvType]="[Physician Assistant]" Or [PerfProvType]="[Midwife]",0.85,1)
Thanks n advance