Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

> and < formula not working right

Posted on 2014-01-13
2
Medium Priority
?
239 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:Kim Williamson
2 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 2000 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:Kim Williamson
ID: 39778233
Duh!  It's always the little things.  Thanks!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Screencast - Getting to Know the Pipeline

783 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