Hello Team,
Could someone help me calculate the three entries a + b + c as shown in my xlsx sheet. Assume there are 'No' other contributors. (Put No in the radio button). The calculation is giving a NAN; your help will really be appreciated.
Orwa
Skiped_question.xlsx (18.3 KB)
Hi @Orwa,
Welcome to the forum!
I think it might just be an error in your formula.
Try this:
Where your formula says:
(${husband_contribution}) + (${wife_contribution}) + (${other_contributors_other})
Put this instead:
(${husband_cont}) + (${wife_cont}) + (${other_cont})
Does that work?
Thanks,
Janna
Hello @Orwa, I send the .xlsx form (solved), and a link with the how work.
Temporal Link: https://odk.enke.to/preview?form=https://xlsform.opendatakit.org/downloads/7wj6_c6o/Skiped_question.xml
Skiped_question.xlsx (18.1 KB)
Example:
Thanks a lot!!! This is brilliant. It worked. I had done so much in a worksheet i was developing. This was my only error.
Thank you Janna!
Putting a 'No' in part 'c' gave me a 'NAN'. But i pulled some new tricks from your response.
Thank you so much Famador.
