Hi Darren

I would suggest looking at Notifications on Opportunities (Conditions being Status = Won and Forecast >=1000 and have it fire off an email).

Darren,

Valid = (oppo_forecast >= '1000.00');

...will always return true. 'oppo_forecast' will be implicitly cast to a string and then compared to '1000.00' - which, as you've put it in quotes, will also be a string. Alphabetically 'o' is 'greater then' '1', so it'll return true. What you should be doing is:

Valid = ((Values('oppo_forecast') >= 1000.00);

In this case we're getting the actual value of the oppo_forecast field - which will be a number - and comparing it to a another number (hence the lack of quotes around 1000.00)

Thanks Chris, I'll give this a go and let you know.

Hi Chris, this worked. Thank you for the assistance. much appreciated.