https://community.esri.com/t5/arcgis-pro-questions/calculate-field/m-p/1503462#M85404 <P>You could just do <EM>Select By Attributes </EM>and look at the number of selected features, couldn't you? But to do it in Arcade, there isn't a direct equivalent to that function. We can recreate it with GroupBy and some SQL:</P><LI-CODE lang="javascript">sql = `CASE WHEN field1 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field2 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field3 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field4 = 'NO OK' THEN 1 ELSE 0 END` var grouped = GroupBy( $layer, // or some FeatureSetBy… function, depends on how you're pulling this data into your expression 'objectid', { name: 'no_ok_count', expression: sql, statistic: 'SUM' } )</LI-CODE> Wed, 10 Jul 2024 12:39:22 GMT jcarlson 2024-07-10T12:39:22Z https://community.esri.com/t5/arcgis-pro-questions/calculate-field/m-p/1503454#M85403 <P>Hello,</P><P>I need to calculate the number of fields that contain a specific text. In excel it would be something like this:<BR />=CONTAR.SI(A2:AG2;" NO OK")<BR />Can you tell me what the expression with Arcade would be?</P><P>Thanks</P> Wed, 10 Jul 2024 12:12:09 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field/m-p/1503454#M85403 Ainosez 2024-07-10T12:12:09Z https://community.esri.com/t5/arcgis-pro-questions/calculate-field/m-p/1503462#M85404 <P>You could just do <EM>Select By Attributes </EM>and look at the number of selected features, couldn't you? But to do it in Arcade, there isn't a direct equivalent to that function. We can recreate it with GroupBy and some SQL:</P><LI-CODE lang="javascript">sql = `CASE WHEN field1 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field2 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field3 = 'NO OK' THEN 1 ELSE 0 END + CASE WHEN field4 = 'NO OK' THEN 1 ELSE 0 END` var grouped = GroupBy( $layer, // or some FeatureSetBy… function, depends on how you're pulling this data into your expression 'objectid', { name: 'no_ok_count', expression: sql, statistic: 'SUM' } )</LI-CODE> Wed, 10 Jul 2024 12:39:22 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field/m-p/1503462#M85404 jcarlson 2024-07-10T12:39:22Z