AnsweredAssumed Answered

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.

Outcomes