this is my equation for an average:(coalesce(${score1_1b},0)+coalesce(${score2_1b},0)+coalesce(${score3_1b},0)+coalesce(${score4_1b},0)+coalesce(${score5_1b},0)+coalesce(${score6_1b},0)+coalesce(${score7_1b},0)+coalesce(${score8_1b},0)+coalesce(${score9_1b},0)+coalesce(${score10_1b},0)+coalesce(${sc…

@janjan , you could do it as outlined in this post discussed previously: [image] Rounding off to lower value Form Building Hi @mahrukhkhan , Would you try out using the round function as shown in the image below: [Image%201] Reference xlsform: Round.xlsx (9.3 KB)

How to round up an average on kobotoolbox?

User Support Form Building

Kal_Lam August 26, 2024, 8:55am 2

@janjan, you could do it as outlined in this post discussed previously: