[SalesForce] Formula field gets populated with respect to other fields

Im using PE.enter image description here

For the calculating of Total commission user must enter the value in either one this two fields(ie., in Consultant Commission % on Opportunity(Percent datatype )or Fixed Value(currency datatype)).If i enter value in Consultant Commission field then (Total commission(Formula field currency) = Consultant Commission % on Opportunity * Final purchase price).If i enter the value in "Fixed value" field the (Total commission =Fixed value) .Im using PE

Note:TC_c=Consultant Commission % on Opportunity * Final purchase price

I tried this formula
IF( NOT ISBLANK( Fixed_value__c ), Fixed_value__c , TC__c )

but I getting this error
Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (7,807 characters). Maximum size is 5,000 characters (Related field: Formula

Best Answer

Try this:

IF(Fixed_value__c!=0 , Fixed_value__c , TC__c)

Related Topic