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
CKGCKG 

Custom report formula

Hi,

I would want to insert Formula to show % on Report (Lead Status).

 

as i go to insert field to formula , i dont find any option to indert Lead status picklist values to formula editor. my report gives record count on open leads, closed, qualified leads,. I even wants to show % for this record counts . please suggest me a solution for the same

 report :

matrix report

column : Lead owner

Row: Lead status

report data: record count based on lead status

 

Solution requied:

 To show the % for Total

 

Open %= row count/ grand total

 

I just wanted to know what would be the syntax for the same

 

Thank you

CK