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.
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)
)
No comments:
Post a Comment