Getting #Error! in a formula field

Basically i am getting this error(#Error!) on using formula field.


Is this happening when Total_Revenue__c is blank or equal to 0?  This would cause the error.  You need to add checks in the formula for if Total_Revenue__c is 0, to prevent trying to divide by 0.

Total_Revenue__c,Total_Cost__c these fields are Formula fields

Solution:-

IF(
     OR(
          ISBLANK(Total_Revenue__c),
          Total_Revenue__c = 0
     ),
     0,
     (Total_Revenue__c - Total_Cost__c) / Total_Revenue__c)
)