We help IT Professionals succeed at work.

Designer Formula question

Michelle Dabney
on
Medium Priority
222 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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2007

Commented:
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 !
CERTIFIED EXPERT
Top Expert 2007

Commented:
@TextToNumber may be useful.

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

I hope this helps !
Michelle DabneyIT Director

Author

Commented:
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.
Michelle DabneyIT Director

Author

Commented:
@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
CERTIFIED EXPERT
Top Expert 2007
Commented:
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 !

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.