AnsweredAssumed Answered

How do I perform arithmetic calculations between data in two different tables?

Question asked by vinhhuy@stanford.edu_Stanford on May 30, 2020
Latest reply on May 31, 2020 by curtvprice

For example, I have one table with the total number of hospital beds in a given county. I have another separate table with the populations in those same counties. Therefore, in order to calculate "hospital beds per person" in a given county, I would have to take the hospital bed number in the first table and divide that by the population number in the second table. I have tried playing around with the "calculate field" tool but I am not familiar with Python or Arcade, and it seems like it can only perform calculations within a single table. Please advise and thank you for your time.

Outcomes