Designer Formula question

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.
Michelle DabneyIT DirectorAsked:
Who is Participating?
 
SysExpertConnect With a Mentor 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 !
0
 
SysExpertCommented:
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
 
SysExpertCommented:
@TextToNumber may be useful.

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

I hope this helps !
0
 
Michelle DabneyIT DirectorAuthor 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.
0
 
Michelle DabneyIT DirectorAuthor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.