I want "Ons" and "Offs" to be greater than 30 then highlight yellow

[capronton]

If ({@PercentDelta} > .12 or {@PercentDelta} < -.12) and
Sum ({apc_correlated.ons}, {apc_correlated.transit_date_time}, "daily") > 30 and
Sum ({apc_correlated.offs}, {apc_correlated.transit_date_time}, "daily") > 30
then crYellow
else crNoColor

The code above highlights the field yellow if "Ons" or "Offs" are greater than 30.

I want to highlight the field only if "Ons" and "Offs" are greater than 30. Can someone tell me whats wrong with the if statement above?

Thanks for any assistance

 

[HowardHammerman]

I guess the important word in your last sentence is ONLY. Right now yellow happens if Percentdelta is in the range. Here is a better statement:

if Sum ({apc_correlated.ons}, {apc_correlated.transit_date_time}, "daily") > 30 or
Sum ({apc_correlated.offs}, {apc_correlated.transit_date_time}, "daily") > 30
then crYellow
else crNoColor

Note the use of OR rather than AND.



Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[capronton]

Great! Thanks Howard, sometimes I get a brain-lock on my AND/OR logic