Use specific field values to perform calculations

Question & Answer
1

I am trying to create a calculated field to find average, but I want to work with the total for that column instead of each value.

image

I am looking to do sum(total)/count(total). But total is not a column name so I cannot really access values in x,y,z. Is there another approach I could try?

2

You can try sumOver or countOver