function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Rodrigo ValdesRodrigo Valdes 

add 2 fields in a report

Hello!

I made a report in my organization salesforce, this report is grouped by a specified field. this specific field has 4 values (Incident, inquiries, requests, BLANK).

I'm trying to add all records "Incident" with BLANK records that have value, but I could not do it.

Problem image

anyone has any idea how to do?

It would be helpful!

regards!
Robert ZentgrafRobert Zentgraf
Hi Rodrigo,

you can create a formula field on this object and the formula give you the three solutions you need from the existing field. I think, this could be a solution:
IF( ISPICKVAL(Incident_Type__c, ''), 'Incidente', TEXT(Incident_Type__c))

Regards
Robert
(mindforce: www.mind-force.de)