So below is what I was asked to calculate. I thought summarize within would cut it but it will not.
This needs to happen for all 6000+ buildings in my city.
Thanks!
Curtis Price I will try your model! Thanks
Can you post an export of your model?
I was able to get my modified way to work. I am still looking at Curtis Price model. I think a model would be easier in the end.
EDIT: I was not able to get my way to work. I thought that I could go
(Y+Y+Y)*a
but this is the formula I need.
Y*b+ y*C