How To BLank A Field With A Numeric Value

[Former Member]

I am trying to write a formula as follows:

IF {CRD1.U_PriceOnPick} = "N" THEN

" "

ELSE

{ODLN.DiscPrcnt}

My problem is I need for the field not to display if = "N" else I will print the numeric field of {ODLN.DiscPrcnt} . I am not sure how to code a formula that will meet my objective. When I try to save the formula, I receive an error of , "A String Is Expected Here". Any help would be appreciated it.

Thanks Jim Dyer

[Former Member · Accepted solution]

Cardinal rule of CR, the result of both the IF and ELSE parts must be of the same data type.

Try changing your formula to:

IF {CRD1.U_PriceOnPick} = "N" THEN

" "

ELSE

totext({ODLN.DiscPrcnt});

[Former Member · Accepted solution]

That worked, thank you for your help.

Jim Dyer