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)
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)