Solved

Crytal if formula

Posted on 2013-01-02
7
306 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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 35

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
[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

 

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 101

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 101

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
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…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

729 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