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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with formula

Status
Not open for further replies.

GCL2007

IS-IT--Management
Dec 11, 2007
167
US
Need a little help with a formula for a report which I inherited. Formula is a section - Suppress Record selection to suppress when the below is false. Having an issue with the ands and the ors in the @variance if statement below.. Picking up everything.... Is there a better way to structure? Want to pick up anything over 108 or between 50 and 92.
Thanks

If {WORKORDER.QTY} < 100
then
(if ({@variance} >= 108 or ({@variance} >= 50 and {@variance}<=92)
and
({@maxdate} = currentdate or {@maxdate} = currentdate-1)) then true)

else
if {WORKORDER.QTY} >= 100
then (if {@variance} >= 108 or ({@variance} >= 50 and {@variance}<=92)
and ({@maxdate} = currentdate or {@maxdate}= currentdate -1) then true)
 
{@variance} < 50
OR
({@variance} >=92
AND
{@variance}<=108)

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top