Setting a Vaule of Column if one of 2 columns has info

Here is my code : IF([Agreed Cleaning Fee] < 1, [Cleaning Fee]=[Computed Cleaning Fee], [Cleaning Fee]=[Agreed Cleaning Fee])

My error : The expression is valid but its result type ‘Yes/No’ is not one of the expected types: Price

What I am doing is have a Column showed to the user. I have a Formula that calculates a fee and another column where i can enter a fee. I want it to be if there is a fee enter but that value in the 3rd column and if not put the other data there.

This:

[Cleaning Fee]=[Computed Cleaning Fee]

is a comparison. The result is the answer to the question, “is the Cleaning Fee column value equal to the Computed Cleaning Fee column value?”

It would appear the expression you want would be:

IF([Agreed Cleaning Fee] < 1, [Computed Cleaning Fee], [Agreed Cleaning Fee])
1 Like

I get this what that:

The expression is valid but its result type ‘Price’ is not one of the expected types: Yes/No

I’d guess you’re using the expression in the wrong location. Where are you trying to use it?