Using currency in an expression

[new2approach]

OK, here's what I've got. I'm new to this program, doing everything through macros, no scripts at this point. I need to perform an expression using currency. I have set a conditional macro to run, like this
If ("WRE 1 Amount">$99 is true run macro Show Over $99 dialog

What's happening is that regardless of WHAT amount I put in the WRE 1 Amount field, the dialog box pops up. What am I doing wrong?

I have defined the WRE 1 Amount field as a currency field.
Any ideas?

 

[paulbent]

You may have formatted the fieldbox to display the number as currency but the underlying field type is numeric. Drop the $ sign from the Run If condition and it should be OK.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk