Topics tagged coalesce

Topic	Replies	Views	Activity
Exclude "99" or "98" from calculation while adding Form Building calculation , calculate , sum , if-statement , coalesce	2	637	September 13, 2021
Adding multiple areas in KoBoToolbox Form Building geoshape , round , coalesce , area-calculation , trigger	2	930	September 8, 2021
Calculated value is not being shown in downloaded data Data Management calculation , data-download , coalesce	11	1036	July 14, 2021
Calculation with positive and negative integers does not work and "NaN" appearing Form Building sum , coalesce	1	911	July 12, 2021
Using the if statement in Kobo Form Building calculation , calculate , if-statement , round , coalesce	1	1862	July 6, 2021
Calculating number of entries in a date format Data Management custom-reports , sum , if-statement , coalesce	8	1062	June 21, 2021
Cumulative percentage equal to 100% Form Building skipping , select-multiple , sum , count-selected , coalesce	6	1728	June 18, 2021
Make a calculation in a form based on active cells Form Building calculation , calculate , sum , coalesce	2	907	June 11, 2021
Total score Form Building calculation , calculate , sum , coalesce	3	687	June 8, 2021
Issues with nested if (condition) function Form Building calculation , calculate , if-statement , round , coalesce	8	1712	May 22, 2021
Handle null values while adding Form Building calculation , calculate , sum , coalesce	3	757	April 23, 2021
Top 3 values Form Building calculation , calculate , if-statement , coalesce , max	5	1277	April 22, 2021
Getting top 3 values Form Building calculate , sum , if-statement , coalesce , max	6	1538	April 22, 2021
Calculation of an unanswered question Form Building calculation , calculate , sum , coalesce	2	658	April 22, 2021
Calculating the sum Form Building calculation , calculate , sum , coalesce	4	5194	April 20, 2021
Division if (I want to run correct calculation of an average) Form Building calculation , calculate , sum , if-statement , coalesce	2	2229	April 15, 2021
Calculate mean score from a Likert scale question Form Building calculation , calculate , sum , if-statement , coalesce	10	7521	April 9, 2021
Question about the max function and missing value Form Building coalesce , max	4	1594	March 18, 2021
Validating a response based on previous questions Form Building constraint , sum , coalesce , constraint_message	1	1148	January 30, 2021
Question Selection and point Calculation (weighted score/simple composite index) Form Building calculation , calculate , sum , if-statement , coalesce	2	2916	October 19, 2020
Requesting Example for Advance Calculation (Composite Index) Form Building calculation , calculate , sum , if-statement , coalesce	7	747	January 12, 2021
Hide field until 5 or more questions have been answered (composite index) Form Building calculation , calculate , sum , if-statement , coalesce	10	1106	January 11, 2021
Calculating a value from NaN Form Building calculation , calculate , coalesce	3	1856	January 11, 2021
Calculation Question type error report Form Building sum , if-statement , odk-validate , coalesce , deploy-error	4	1119	January 9, 2021
Adding 5 variables when 2 variables are null , in this total value not showing? Form Building sum , if-statement , coalesce	16	2593	December 28, 2020
Help to make a report of a determinate zone in percentage that add up to 100% Form Building constraint , if-statement , coalesce , constraint_message	2	791	December 18, 2020
Reverse score calculations (composite index) Form Building calculation , calculate , sum , if-statement , coalesce	2	1279	December 15, 2020
Sum total the EMI automatically once it is selected from a select multiple question Form Building calculation , cascading-selects , select-multiple , if-statement , coalesce	5	1414	December 4, 2020
If statement to score 'select many' responses Form Building select-multiple , sum , if-statement , coalesce	7	2083	November 6, 2020
How summing values assigned to an answer and how assigning same values to different answer options Form Building select-multiple , sum , if-statement , coalesce , selected-at	12	2541	October 5, 2020