Help with a formula 1

[cyreports]

Not sure why, but I am getting a value of DoctorsNPI when I test and I know the specialcase = 2 and the carrier equals MEDICAID IA.

if {Claims_txt.SpecialCase} = 1 then
     ""
   else if {Claims_txt.SpecialCase} = 2 and {Claims_txt.InsuranceCarrierName} <> "MEDICAID IA" then
     {Claims_txt.DoctorsNPI}
      else if {Claims_txt.SpecialCase} = 3 then
         ""
       else if {Claims_txt.SpecialCase} =4 then
            ""

 

[kray4660]

Be very careful with string comparison's, if is there is an extra leading or trailing space, then it will not match.

I hope this helps.

 

[cyreports]

Thanks

 

[lbass]

Depending upon how you have your report options set up, case might be a factor as well.

-LB