I am trying to work out a ratio between two columns (each with many rows) of data.
I have one column, named 'amounts' with varying numbers in them, each one is a reference for a area (A polygon, so each polygon has a amount assigned to it)
with another column with the same type of data (lets call it amounts2), I need to calculate the total of the amounts and amounts2 columns and then divide amount2 by amounts2, giving me a ratio. how would I go about doing this?
أكثر...
I have one column, named 'amounts' with varying numbers in them, each one is a reference for a area (A polygon, so each polygon has a amount assigned to it)
with another column with the same type of data (lets call it amounts2), I need to calculate the total of the amounts and amounts2 columns and then divide amount2 by amounts2, giving me a ratio. how would I go about doing this?
أكثر...