Domino Designer formula question

[mdabney]

I keep getting a "Comparison operatiors must be supplied two values of the same data type error". Problem is I'm not sure if my formula is correct as I am not a developer. Does anyone know of a formula that work for"

If field A <=5 and field B=NULL error, if not success.

This is my latest attempt and I get the error
@If(Rating<=5 & Comments=""; @Failure("You Must Enter Comments if Rating is 5 or lower");@Success)

 

[pmonett]

Typical type discrepancy in variables. What is your Rating field ? A radio button list ? In that case, your values are text, so using A <= 5 should read A <= "5".

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[mdabney]

Thanks. It's a list box. I thought that my problem was that I had a numerical field and a text field.

 

[czigh]

I think you're right. So your code would be:

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