You need to sign in to do that
Don't have an account?
JaxBeach
How do you have #Error! not show up in a formula result and replace it with 0?
Hi,
I have a simple formual that calculates sales growth percent.
Current YTD Sales Annualized / Current Year Goal or
Current_TYD_Sales_Annualized__c / Current_Year_Goal__c
how can I have it return a result of 0 instead of an #Error! if either of those to fields contain a zero or null value?
Thanks
Just to make it a better solution, here is the correct code:
Feel free to change the solution to this one. Cheers!
All Answers
Thanks. The syntax is coming up correct, but it still returns an #Error!
does that formula just correct it if it is blank and not if one of the fields is zero?
Yes, sorry, I neglected concern for if they are 0.
Got the following error message:
Error: Incorrect parameter type for function 'IF()'. Expected Text, received Number
What is the output type of your formula field?
% - Percentage
Remove the quotation marks around the zero in the first line.
Thank you so much!!!!!!!!!!!! That worked :-)
Just to make it a better solution, here is the correct code:
Feel free to change the solution to this one. Cheers!
Thanks again :-)