I am attempting to write a formula field that will give me one calculated result if one statement is true, else 0.
Fields:
"Deals.Business area"
"Deals.Power - MWe"
"Deals.Probability (%)"
What i need as an example is, if you find in the field "Business area" the result "PV Self Consumption",
calculate this ${Deals.Power - MWe}*94.5*(${Deals.Probability (%)}/100
If not, give me 0
I've been trying with boolean and string formula return types, with If and Contains function but only getting syntax errors.
Thank you in advance.