Hello,

I have a large form where some fields that are calculated build on each other. I have some pretty basic addition calculations of previous fields I need some of the last fields to complete, that I cannot get to work. There are slightly more complicated conditional statement calculations that work fine, so I'm having a difficult time figuring out why the addition won't work.

In the attached xlsx file, I would like row 443 to sum rows 438 through 442 , row 450 to sum rows 445 through 449, row 457 to sum rows 452 through 456, row 464 to sum rows 459 through 463, and row 471 to sum rows 466 through 470. Currently, nothing appears in these fields, when the sums should be appearing. Any help would be greatly appreciated!!!

Thank you,

Mikala

Hi Mikala,

It looks like your calculations are cascading (i.e., the lines 438-442 all are calculations themselves). Are any of the original values ever blank (and thus NaN - Not a Number)? If so, that would cause an issue with subsequent calculations as

NaN+1 = NaN- the blank carries through the rest of the calculation chain.One way to resolve this is to place each of the values in the addition in a

coalesce(${q}, 0)function - that will provide a fallback value of 0 if the question is empty.