Topics tagged coalesce

Topic	Replies	Views	Activity
Exclude "99" or "98" from calculation while adding Form Building calculation , calculate , sum , if-statement , coalesce	2	627	September 13, 2021
Adding multiple areas in KoBoToolbox Form Building geoshape , round , coalesce , area-calculation , trigger	2	917	September 8, 2021
Calculated value is not being shown in downloaded data Data Management calculation , data-download , coalesce	11	1018	July 14, 2021
Calculation with positive and negative integers does not work and "NaN" appearing Form Building sum , coalesce	1	904	July 12, 2021
Using the if statement in Kobo Form Building calculation , calculate , if-statement , round , coalesce	1	1859	July 6, 2021
Calculating number of entries in a date format Data Management custom-reports , sum , if-statement , coalesce	8	1021	June 21, 2021
Cumulative percentage equal to 100% Form Building skipping , select-multiple , sum , count-selected , coalesce	6	1691	June 18, 2021
Make a calculation in a form based on active cells Form Building calculation , calculate , sum , coalesce	2	904	June 11, 2021
Total score Form Building calculation , calculate , sum , coalesce	3	683	June 8, 2021
Issues with nested if (condition) function Form Building calculation , calculate , if-statement , round , coalesce	8	1687	May 22, 2021
Handle null values while adding Form Building calculation , calculate , sum , coalesce	3	746	April 23, 2021
Top 3 values Form Building calculation , calculate , if-statement , coalesce , max	5	1269	April 22, 2021
Getting top 3 values Form Building calculate , sum , if-statement , coalesce , max	6	1524	April 22, 2021
Calculation of an unanswered question Form Building calculation , calculate , sum , coalesce	2	650	April 22, 2021
Calculating the sum Form Building calculation , calculate , sum , coalesce	4	5135	April 20, 2021
Division if (I want to run correct calculation of an average) Form Building calculation , calculate , sum , if-statement , coalesce	2	2216	April 15, 2021
Calculate mean score from a Likert scale question Form Building calculation , calculate , sum , if-statement , coalesce	10	7415	April 9, 2021
Question about the max function and missing value Form Building coalesce , max	4	1574	March 18, 2021
Validating a response based on previous questions Form Building constraint , sum , coalesce , constraint_message	1	1132	January 30, 2021
Question Selection and point Calculation (weighted score/simple composite index) Form Building calculation , calculate , sum , if-statement , coalesce	2	2876	October 19, 2020
Requesting Example for Advance Calculation (Composite Index) Form Building calculation , calculate , sum , if-statement , coalesce	7	736	January 12, 2021
Hide field until 5 or more questions have been answered (composite index) Form Building calculation , calculate , sum , if-statement , coalesce	10	1075	January 11, 2021
Calculating a value from NaN Form Building calculation , calculate , coalesce	3	1832	January 11, 2021
Calculation Question type error report Form Building sum , if-statement , odk-validate , coalesce , deploy-error	4	1106	January 9, 2021
Adding 5 variables when 2 variables are null , in this total value not showing? Form Building sum , if-statement , coalesce	16	2455	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	786	December 18, 2020
Reverse score calculations (composite index) Form Building calculation , calculate , sum , if-statement , coalesce	2	1254	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	1407	December 4, 2020
If statement to score 'select many' responses Form Building select-multiple , sum , if-statement , coalesce	7	2045	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	2495	October 5, 2020