Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How To BLank A Field With A Numeric Value

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
Former Member replied

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});

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question