Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FRx IF THEN ELSE formula help 1

Status
Not open for further replies.

Shipley

Technical User
Feb 23, 2005
8
US
I am trying to write an if-then-else statement in FRx that displays a word as the result. This is what I am currently working with:

IF @600 <= .9 THEN "YES" ELSE "NO"

I am also writing one that displays a number as a result

IF @720 < 0 THEN 0 ELSE @720

Unfortunately both of these formulas do not work properly. The error message that pops up is:

"There is only one special format mask allowed in a intRow and it should be the last data entered"

Any ideas how to fix this?
 
I got the same error trying it. I don't think you have the option of showing text in a value column.

There may be some way to play around with the column layout, and have a column show text, and print that column in place of the value in row 720. I dont have time to try anything but if I do Iwill let u know.

Thanks!
Barb E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top