I'm trying to do a simple division, using data from two different list boxes, which contain the same fields, but from different sources. One list box contains total number of properties per neighbourhood, the other list box contains number of complaints per neighbourhood. I wish to divide the number of complaints per neighbourhood figure by the total number of properties per neighbourhood, to give the average number of complaints per property for each neighbourhood. Simple to do on a calculator or on Excel!
Does anyone know which expression needs to be used - I have tried many different permutations, none of which gives the right answers.
