I am trying to create a formula field to display a "clean" value for our revenue. It is a formula based on opportunity fields and it's a field displayed in the opportunity itself. We have several record types in our org and I am testing different fields including the record type. I am receiving this error message when I check the syntax
Error: Incorrect parameter type for function 'if()'. Expected Number, received Text
and I don't understand why.
if(RecordType.Name="New Biz - Site Level", if(Is_Natural_Expansion__c=true, MRR_estimated__c, if(ISPICKVAL(Type, "Upsell"), MRR_estimated__c, if(MRR_at_deployment__c>0, MRR_at_deployment__c, MRR_at_deployment__c))), if(ISPICKVAL(Type, "Upsell"), MRR_estimated__c, ""))