I need to create a custom formula field on Opportunity object that will sum 2 currency fields -Annual_Recurring_Revenue_(ARR) + Manager_Forecast_Amount. The trick is that i need to add the value from Annual_Recurring_Revenue_(ARR) field when the opportunity is in stage WON only, if it's not in stage WON it should give the field the value $0.
Thank you for helping!
8 respuestas
Thanks!
Okay so you Formula should be something like this thenIF( IsWon = TRUE, Annual_Recurring_Revenue__c , Manager_Forecast_Amount__c )
