Report Formula: If Opportunity Sold return told; If not then return 10% of Total.

Question

I'm trying to write a formula on a report and need help with the below formula. If Opportunity Sold/Won return told; If not then return 10% of Total. Please help!

Abby Sisk · Accepted Answer

Figured it out! :)

Derhyk Doggett · Answer

Hi Abby,   I'm not sure you can make a formula with an if statement in a report formula. I haven't used them much so could be wrong. (This post from 2013 suggests you cannot, but Salesforce may have implemented it since:  https://success.salesforce.com/answers?id=90630000000gwbGAAQ ). To make the formula on the Opportunity if you be something like the below.   (I'm assuming told is a typo for Total, if I'm wrong let me know and we can adjust accordingly)   Create Formula field, type: Currency   Forumla   IF( IsWon ,  Amount , Amount*0.1)   Hope that helps.   -derhyk

Report Formula: If Opportunity Sold return told; If not then return 10% of Total.

Reports & Dashboards

Related Learning

More Help