Solved

between function

Posted on 2008-10-15
2
900 Views
Last Modified: 2012-05-05
Unable to create a between statement  

if {@Markup %} is >= .41 and <= .4999 then .07

I have tried
"Iif Between({@Markup %} , 0.41  , 0.419999), { 0.07}, 'NULL' else" and receive remaining text does not appear to be a formula
0
Comment
Question by:kgittinger
2 Comments
 
LVL 42

Expert Comment

by:zephyr_hex (Megan)
ID: 22727802
if {@Markup} between .41 and .4999 then .07;

i don't have my copy of crystal reports available to me right now so i can't verify i have it right.
0
 
LVL 5

Accepted Solution

by:
jgbreeden earned 500 total points
ID: 22728088
To use the AND statement, lose the 'is' and repeat the value on the left side of the equal sign:
if {@Markup %} >= .41 and {@Markup %} <= .4999 then .07

I personally like that better than the between statement, it's more obvious whether you are getting >= or just >
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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