I'm trying to create a formula field base on the values(0,1,2,3) in the opportunity_salesstage which is a val data type.
My formula field is called Weighted revenue and wonder which function to use for this.
Trying to achieve this:
weighted revenue = if (opportunity_salesstage = 0, (0,1 * expected revenue))
weighted revenue = if (opportunity_salesstage = 2, (0,3 * expected revenue))
weighted revenue = if (opportunity_salesstage = 3, (0,95 * expected revenue))
Thx
Anders