Kim Williamson
asked on
> and < formula not working right
I have a report that I am trying to say if one field is greater than 95 but less than 105 it should change the field value to Y or N depending on whether it falls within this range. Looks like it will say Y at the 100% mark, but one value is at 106 and still says Y.
If ({@Accuracy} >95 or {@Accuracy} < 105) then "Y" else "N"
Can you see any issue?
If ({@Accuracy} >95 or {@Accuracy} < 105) then "Y" else "N"
Can you see any issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER