Formula Error String Unknown

[bstafford21]

Hello,

Have a problem to figure out on how to write the formula properly to change my font on a string indicator field. Not sure how the proper format is on this one as I can get other fields to change font color by using the following:

if {Part.Stored_Qty} < {SO_Items.Qty} then CrRed Else CrBlack
This formula works for the required indicator, but trying to use the below formula for font color change when the "Ops.Completion_Indicator_YN is = to N" I want it to be RED. but get an error on this one. This field in my database is a string, how to get this type string to work in a font color change?

if {Ops.Completion_Ind_YN} = {(N)} then CrRed Else CrBlack

Any help here is appreciate if someone knows what I should be writing in the formula, I am sure it is simple, but don't know how.

Thanks

Bill

 

[IanWaterman]

Try

if {Ops.Completion_Ind_YN} = 'N' then CrRed Else CrBlack

If 'N' is not correct place {Ops.Completion_Ind_YN} on report and see what values are returned.

Ian