Skip to main content Stream TDX Bengaluru on Salesforce+. Start learning the critical skills you need to build and deploy trusted autonomous agents with Agentforce. Register for free.

I need help with a formula on my report. We are looking to find the percentage of students who have passed.

 

Formula to calculate percentage of Pass Rate

 

The formula i have got are all showing as 25% which cannot be right. 

 

formula.JPG

 

I have also created a Pass Count formula field on the ILM Assessment Answersheet object but every record is showing as a 0

 

IF(TEXT(Status__c) = "Pass",1,0)

 

What am i doing wrong? #Trailhead #Report Formula #Reports & Dashboards

4 answers
  1. Nov 4, 2021, 8:24 AM

    Please change a little.

     

    RowCount / PARENTGROUPVAL(RowCount, ILM_Qualification_Answersheets__c.ILM_Level__c)

     

    Please change a little. RowCount / PARENTGROUPVAL(RowCount, ILM_Qualification_Answersheets__c.

Loading
0/9000