I created the following formula in a report but the owner full name is always empty, so the result value is always 2 instead of 1.
Here is an example of the code:
IF(FULL_NAME=='Mark Anderson',1,2)
Not sure what I'm doing wrong.
Thanks
I created the following formula in a report but the owner full name is always empty, so the result value is always 2 instead of 1.
Here is an example of the code:
IF(FULL_NAME=='Mark Anderson',1,2)
Not sure what I'm doing wrong.
Thanks
This can't be achieved with summary formulas on reports.
I wasn't able to find a source that states what summary formula can't support, only what it can:
Regardless of the summary formula data type, your summary formula can contain fields of different data types, including: number, currency, percent, and checkbox (true/false) fields.
[Source: Get the Most Out of Summary Formulas: Tips, Limits, and Limitations]
Another way to achieve what you want, is to create a custom formula that returns text on the Opportunity Object.