Not sure why I am getting the error for having "
IF( Payoff_Amount__c - Funding_Amount__c > 0, Payoff_Amount__c - Funding_Amount__c , "None")
Error: Incorrect parameter type for function 'IF()'. Expected Number, received Text
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityYour formula is returning mixed types. If Payoff_Amount__c - Funding_Amount__c > 0
, you return a number, Payoff_Amount__c - Funding_Amount__c
. But otherwise, you return a string value, "None"
.
Formulas must return a consistent type. If you want to use the word "None", you'd need to change your formula to a Text type and convert the dollar value to text as well, using the TEXT()
function.
None