Solved

Designer Formula question

Posted on 2006-11-07
5
206 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 125 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

792 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