Displaying value after formula determines result 1

[Stewman]

Hello,

I am new to crystal and not a programmer. I have a quick question. I am trying to create a formula where I say if 1 field is greater than another field then display a certain value.

For example:
If {INVENTORY.REORDERPOINT} > {INVENTORY.REORDERQTY} then
I want the word "reorder" to be displayed.

If the value is not met then I do not anything to appear. Any help greatly appreciated. I know this is simple, just not able to figure it out.

 

[synapsevampire]

Oh, you were soooooooo close...

Right click Formulas in the Field Explorer and select New, and after naming it use something akin to:

If {INVENTORY.REORDERPOINT} > {INVENTORY.REORDERQTY} then
"Reorder"
else
""

-k

 

[Stewman]

Thanks for the quick response. That worked perfectly.