Vocabulary of calculation formulas usable on Kobo

[Kal_Lam]

@Sylvain_DOAMBA, this post discussed previously should also be helpful for you:

How do i calculate the sum of a number of variables?

Hi @silasdasgupta There is a simple solution for your issue which is to use “coalesce” function coalesce ( arg , arg ) Returns first non-empty value of the two arg s. Returns an empty string if both are empty or non-existent. Kindly see the example: [image] Coalesce_example.xlsx (11.4 KB) Let me know if you have any question. Best, Yasser