I need help with a formula on my report. We are looking to find the percentage of students who have passed.
The formula i have got are all showing as 25% which cannot be right.
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 件の回答
Please change a little.
RowCount / PARENTGROUPVAL(RowCount, ILM_Qualification_Answersheets__c.ILM_Level__c)