Alternate Method of Adding values in two fields

123
1
2 weeks ago
Labels (3)
DanielDuncan
New Contributor

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. 

 

0 Kudos
1 Reply
jafarpb
New Contributor

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.

0 Kudos