Solved

Crytal if formula

Posted on 2013-01-02
7
297 Views
Last Modified: 2013-02-13
I need help with a formula that show true if the price ends with a 0 or 5 and False if not.

Thanks!!!!
0
Comment
Question by:evend
7 Comments
 

Accepted Solution

by:
FLProfessional earned 167 total points
ID: 38738726
it's a little dirty, but this should work:


local stringvar checkprice:=ToText(table.price, 2);

If { MID(checkprice,len(checkprice),1) = "0" or MID(checkprice,len(checkprice),1) = "5"} Then
   //put whatever you want here, it's true
Else
   // it's false
End If
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 167 total points
ID: 38738910
Does price have decimals?  If so the formula above should work but it would be easier with RIGHT instead of MID

local stringvar checkprice:=ToText(table.price, 2);

If { Right(checkprice,1) = "0" or MID(checkprice,1) = "5"} Then
   //put whatever you want here, it's true
Else
   // it's false
End If

Open in new window


If prices are in dollars (no cents then)

local stringvar checkprice:=ToText(table.price, 0);

If { Right(checkprice,1) = "0" or MID(checkprice,1) = "5"} Then
   //put whatever you want here, it's true
Else
   // it's false
End If

Open in new window


mlmcc
0
 
LVL 34

Assisted Solution

by:James0628
James0628 earned 166 total points
ID: 38739304
Converting the price to a string, as in the posts above, is the most flexible solution.  Then you can check for any digits you want.

 But since you're specifically looking for 0 and 5, Mod is another option.

 If your field is an integer:

({price field} Mod 5) = 0


 If your field has 2 decimal places and you want to check the last decimal place:

(({price field} * 100) Mod 5) = 0


 James
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:evend
ID: 38883125
I've requested that this question be deleted for the following reason:

A friend helped me with.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38872251
What was your solution, you have 3 very plausible comments.

Did you try any of them?

If so what was the result?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 38883126
You need to address the comments from the experts before deleting this question.

The comments provided are viable solutions which should be accepted as such

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

912 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now