Ask Search:
Racheal DalesRacheal Dales 

Percentage Growth or Decline Formula Field Help

I have a custom formula field which calculates the Forecasted Growth or Decline Percentage using this formula -
 
( Total_Forecasted_Margin_for_2020__c - Margin_Revenue_2019__c )/ Total_Forecasted_Margin_for_2020__c

The issue I'm having is when I use this field in reporting I am getting errors for the lines that have zeros in the fields represented in the formula.  How can I adjust the formula properly to still calculate and recognize the zeros without an error?  I need to be able to sum this field up by each rep within the report and it's not working because of the zeros.  Thanks in advance! 
Best Answer chosen by Racheal Dales
Deepak AnandDeepak Anand
Try this = 
IF(
    BLANKVALUE(Total_Forecasted_Margin_for_2020__c, 0) = 0,
    0,
    (Total_Forecasted_Margin_for_2020__c - Margin_Revenue_2019__c) / Total_Forecasted_Margin_for_2020__c
)

All Answers

Deepak AnandDeepak Anand
Try this = 
IF(
    BLANKVALUE(Total_Forecasted_Margin_for_2020__c, 0) = 0,
    0,
    (Total_Forecasted_Margin_for_2020__c - Margin_Revenue_2019__c) / Total_Forecasted_Margin_for_2020__c
)
This was selected as the best answer
Racheal DalesRacheal Dales
Thanks again Deepak for coming to my rescue!