Hi guys,

I wanted your help with something. I have designed a form and when doing pretesting, I have realized one of the formulas is giving an output of "2" even when all the entries are zero.

I will attach the form here so that you can have a look at it. I have highlighted the line with the misbehaving formula "line 398."

Your assistance is highly appreciatedMothers_questionnaire.xlsx (42.8 KB)

.

Regards.

Hi @TheuriKingori,

Your formula/calculations seems to be okay. Have you highlighted the correct place?, because row 398 is not . But you have issue here `${totalhhpurchaseann}div12`

. Do you intend to divide? Then you should use appropriate symbol

Hi @dicksonsamwel,

Thank you for getting back.

The intention in ${totalpurchaseann}div12 was to divide the annual expenditures in order to get monthly expenditures.

However, while summing up the total annual expenditures "totalhhpurchaseann" the formula is working correctly but with a mysterious addition of "2."

My guess is that you are writing ` ${totalhhpurchaseann}div12`

and you should write ` ${totalhhpurchaseann} div 12`

(note the space before and after div).

Thank you @yanokwa for pointing that out, hadn't noted; let me amend that. However, I would like to point you to questions H57 through to H73. When summing up the entries from these questions, I am getting a mysterious "2". For instance, when the entries are 5000 for each question the final output is 80002. Note there was no 2 entered in any of the responses. Similarly, when I don't include anything in the responses and I just tick "no" for each, the summation on total annual "totalhhpurchaseann" gives me a "2".

Kindly assist.

Hi @TheuriKingori,

It is not mysterious, your formula have issues, you have used a yes no value instead of the value in `hhpurchaseland`

. Checking yes, will assign that variable a '1'. Check your other variables.

Dickson

3 Likes

Hi @dicksonsamwel,

Thank you so much. You sure have an eye for this things. I have been going through it countless times and I could not identify the problem.

Saved me big time.

3 Likes