You need to sign in to do that
Don't have an account?
b.gonzalez
Custom Formula Field on Opportunity?
I am trying to create a Closed Won amount custom formula field. When the Stage = Closed Won, the fiield should display the Amount value if the 'Total Amount for Current FQ' is $.0.00 or 'Null' or the 'Total AMount for Current FQ' value. I am not sure how to write these formula. Here are the fields that would be in the formula:
StageName = Closed Won
Total_Amount_for_Current_FQ__c
Amount
I appreciate the help!
Thanks!
StageName = Closed Won
Total_Amount_for_Current_FQ__c
Amount
I appreciate the help!
Thanks!
Here is the formula for you
Keep its return type is currency ( if you want)
Mark this answer is best answer so that it can help others as well.
Thanks
Sandeep Singhal
http://www.codespokes.com/
All Answers
Here is the formula for you
Keep its return type is currency ( if you want)
Mark this answer is best answer so that it can help others as well.
Thanks
Sandeep Singhal
http://www.codespokes.com/
IF(ISPICKVAL( StageName , 'Closed Won'), IF(OR(Total_Amount_for_Current_FQ__c= 0.0, ISNULL(Total_Amount_for_Current_FQ__c)), Amount, Total_Amount_for_Current_FQ__c), 'AnyotherValueORfield')
Thanks
Sandeep Singhal
http://www.codespokes.com/
Beth