https://community.esri.com/t5/arcgis-survey123-questions/complex-calculations-using-the-stats-function-in/m-p/1596799#M61738 <P>I would like to calculate some stats in my report bason the stats function:</P><P>&nbsp;</P><LI-CODE lang="sql">${mainLayer | where:"status='Pass'" | stats:"count,objectId"} / (${mainLayer | where:"status='Pass'" | stats:"count,objectId"} + ${mainLayer | where:"status='Fail'" | stats:"count,objectId"})</LI-CODE><P>&nbsp;</P><P>I am not sure where to add the operator or if you can only calculate fields and not stats.</P> Tue, 18 Mar 2025 20:28:45 GMT TL2 2025-03-18T20:28:45Z https://community.esri.com/t5/arcgis-survey123-questions/complex-calculations-using-the-stats-function-in/m-p/1596799#M61738 <P>I would like to calculate some stats in my report bason the stats function:</P><P>&nbsp;</P><LI-CODE lang="sql">${mainLayer | where:"status='Pass'" | stats:"count,objectId"} / (${mainLayer | where:"status='Pass'" | stats:"count,objectId"} + ${mainLayer | where:"status='Fail'" | stats:"count,objectId"})</LI-CODE><P>&nbsp;</P><P>I am not sure where to add the operator or if you can only calculate fields and not stats.</P> Tue, 18 Mar 2025 20:28:45 GMT https://community.esri.com/t5/arcgis-survey123-questions/complex-calculations-using-the-stats-function-in/m-p/1596799#M61738 TL2 2025-03-18T20:28:45Z