# Maths just don't add up....

Question asked by abdigitaluk on Sep 25, 2018
Latest reply on Sep 25, 2018 by richardsrussell

Ok so on the surface this seems like a really simple mathematical rule. I want a field that shows me the total number of food parcels provided to a family in a 7 day week. For example. A family consists of 2 adults and 3 children making 5 persons. This number then needs to be multiplied by 7 ( the days in a week ) which should bring back a result of 35. I will then multiply this number by the number of times we deliver to them so this will increase as the delivery field is increased. However for some reason when I created a field I get the result of number 70? Currently there is only 1 delivery so I know it should only read 35. If I increased deliveries to 2, it does the maths correctly, however shows 140 which is the 70 multiplied by 2.

Essentially I have the following fields

No. Adults - as a dropdown

No. Children - as a dropdown

Deliveries - number entry

I've created a new calculation field called Total Food Parcels, and have applied the following calculation to this field;

No. Adults * No. Children * 7 * Deliveries

Any advice would be greatly appreciated.