Creating a conversion rate
I'm currently putting together a way to track leads from leaflet deliveries, I've got it all up and running in Excel, and have now moved it into FileMaker and it's all working there as well. The only area I've got stuck on is working out the conversion rate in FileMaker, something that was very easy in Excel.
So the question I have is how do I add number in certain columns but not all the columns, and then divide it by another total amount of a column.
So I have 'leaflets delivered' column, which i need to add up all the rows in that one column and then divide it by the total rows in two other columns to work out the conversion rate.
Does anyone know how to do this?