Solved

> and < formula not working right

Posted on 2014-01-13
2
228 Views
Last Modified: 2014-01-13
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?
0
Comment
Question by:delta1734
2 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 39778144
You need to use AND instead of OR.
OR will be awlays true because the value will be either over 95or less than 105. 106 is over 95 nad that is why is true.

You need to use AND:
If ({@Accuracy} >95 AND {@Accuracy} < 105) then "Y" else "N"
0
 

Author Closing Comment

by:delta1734
ID: 39778233
Duh!  It's always the little things.  Thanks!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question