Hello, I'm new to Lookup Helper and starting to use their tutorials to learn how to use the application. I just started the Easily Monitor Inventory in Salesforce With an Inventory Level Object tutorial which has you create a formula field called Amount in a custom object called Part. The formula is IF(Amount__c > 20, "High", IF(Amount__c > 10, "Medium", "Low") ) but when I check the syntax I get the following error message - Error: Incorrect parameter type for operator '>'. Expected Text, received Number. Seems strange they would publish this tutorial with a wrong formula. Can anyone tell me what's wrong with this formula? Thanks in advance for any help.
Hello Glenn,
It sounds like you have the Amount field set to a text value data type when it should be number in order to do the comparison with a > operator.
You can use the value function in the formula if you would like to convert a text value to a number value without having to change the data type of the field like:
Value(Amount)
https://help.salesforce.com/s/articleView?id=sf.customize_functions_value.htm&type=5
