Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Designer Formula question

Posted on 2006-11-07
5
Medium Priority
?
211 Views
Last Modified: 2013-12-18
I need a formula for a form that says if field A is <=5 and field B is NULL return an error.  If field A is >= 5, field B can be blank.

I keep getting an error that comparison operators must be supplied two values of the same data type.
0
Comment
Question by:Michelle Dabney
  • 3
  • 2
5 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 17893515
1) Formula sometimes has isues with trying to detect nul fileds.

What kind of fields are these ( String, numerical ? )

t may be wise to convert them according to the type of compare needed.

If A  is a string convert it to a number first.

I hope this helps !
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 17893534
@TextToNumber may be useful.

Please post your formula so that we can try to correct it.

I hope this helps !
0
 

Author Comment

by:Michelle Dabney
ID: 17893544
A is a numerical rating, B is a text field for comments.  I need the formula to require comments if the rating is less than 5.
0
 

Author Comment

by:Michelle Dabney
ID: 17893554
@if(Rating="";@failure("You must enter a Rating");@Success);
@If(Rating<=5 & Comments=""; @Failure("You Must Enter Comments if Rating is 5 or lower");@Success);
@If(Rating=>5 & Comment=""); @Success
0
 
LVL 63

Accepted Solution

by:
SysExpert earned 500 total points
ID: 17893602
Correct the last 2  :

@If(@TextToNumber(Rating)<=5 & Comments=""; @Failure("You Must Enter Comments if Rating is 5 or lower");@Success);

@If(@TextToNumber(Rating)>5 & Comment=""); @Success

I hope this helps !
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

577 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