Skip to main content 5分間のコミュニティアンケートにご協力ください。2025/4/11 まで回答を受け付けております。こちらをクリックするとご参加いただけます。

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 件の回答
  1. 2021年11月4日 8:24

    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.

読み込んでいます
0/9000