@Kal_Lam , coalesce worked. Thanks a lot.
I still have a question though. As mentioned in original question, the calculation was being performed in the survey form during the survey (without coalesce). The result was visible in the survey form (image attached in opening post). But it did not appear in the downloaded data. Why does this happen?
