Make a calculation in a form based on active cells

Bjr le forum. SVP comment insérer un calcul automatique dans un formulaire en fonction des cellules actives

@djosed, could you explain more on this? Have you had a chance to go through our support article Calculate Question Type and Advanced Calculate Question Type? It should help you have a glimpse of how a calculation is made in KoBoToolbox.

Besides, you could also explore our posts made in the community here.

Hi,
If I understand you correctly, you wanted to be able to do a calculation even if the question has been skipped?E.g. You have Q1 Q2 Q3 Q4 Q5 AND Q6 where Q6= sUM OF Q1 TO Q5. However when Q2 is skipped it should (hypothetically) skipped in that calculation too.

If this is the case, you don’t necessarily need to skip it but rather you need to use the coalesce future . You can look at the following discussions to better implement this

https://community.kobotoolbox.org/tag/coalesce

Stephane

1 Like