https://community.esri.com/t5/arcgis-dashboards-questions/alternate-method-of-adding-values-in-two-fields/m-p/1409767#M9411 <P>I think even an Index/Match/Match formula, done twice, would be better than the SumProduct formula. If nothing else, it would be immensely faster to calculate.</P> Mon, 15 Apr 2024 15:20:47 GMT jafarpb 2024-04-15T15:20:47Z https://community.esri.com/t5/arcgis-dashboards-questions/alternate-method-of-adding-values-in-two-fields/m-p/1409759#M9410 <P>I am using ArcGIS Dashboard, the Election Results solution. I am attempting to collate data and present it in a list element to give a comprehensive outlook on voting results. In particular using advanced formatting to calculate the total ballots cast across all constituencies, boxes remaining to be counted, voter turnout etc. However, I do not have access to the profile variable ($feature) in order to access these fields in my dataset and perform these calculations on the fields. The only profile variable I have access to is the "$datapoint" variable which only gives access to the individual values in each respective field. Hence my question, is there an alternate method, preferably using arcade but open otherwise for me to calculate these values and present in my list element.&nbsp;</P><P>&nbsp;</P> Mon, 15 Apr 2024 14:54:16 GMT https://community.esri.com/t5/arcgis-dashboards-questions/alternate-method-of-adding-values-in-two-fields/m-p/1409759#M9410 DanielDuncan 2024-04-15T14:54:16Z https://community.esri.com/t5/arcgis-dashboards-questions/alternate-method-of-adding-values-in-two-fields/m-p/1409767#M9411 <P>I think even an Index/Match/Match formula, done twice, would be better than the SumProduct formula. If nothing else, it would be immensely faster to calculate.</P> Mon, 15 Apr 2024 15:20:47 GMT https://community.esri.com/t5/arcgis-dashboards-questions/alternate-method-of-adding-values-in-two-fields/m-p/1409767#M9411 jafarpb 2024-04-15T15:20:47Z