 # Adding 5 variables when 2 variables are null , in this total value not showing?

a=2, b=3, c=4, d=5, e=6 adding all ( total = 18)
a= 2, b= not putting any value, c=not putting any value, d=4, e=7 then Total = not showing

Could you be more specific with your issue? It’s a bit unclear. In the mean time would you also mind having a look at some similar post that has been discussed previously (it should help you better understand your situation).

Weighted score problem solved.

New problem is that
Lets
Calculate total value
Input Crop =2 ( required question)
Input Rice =4 (not required question)
Input Wheat =6 ( required question)

Total = \${Crop}+ \${Rice}+ \${Wheat}
If someone give all the input then we get Total value no problem
When someone not give the input Rice then Total value not shown

Hi @mahabbat
The issue can be resolved by reworking your calculations using the if functionality or the coalesce functionality as shown below

e.g. for If

(if(\${crop1}=’’,0,\${crop1}))+(if(\${crop2}=’’,0,\${crop2}))+(if(\${crop1}=’’,0,\${crop2})) + etc

e.g for colasce

coalesce(\${crop1},0)+coalesce(\${crop2},0)+ etc

This should sort out your issue with the blanks

Regards,
Stephane

1 Like

New problem is that
Lets
Calculate total value
Input Crop =2 ( required question)
Input Rice =4 (not required question)
Input Wheat =6 ( required question)
I want to add three question’s input value that is total but one of these questions is not answered total not showing or not calculated

Total = \${Crop}+ \${Rice}+ \${Wheat}

If someone give all the input then we get Total value no problem
When someone not give the input Rice then Total value not shown

Thanks for helping

1 Like

Please find herewith the attached KOBO form and advise me how I will do it.

(Attachment Training Data Collection _ KoboToolbox.pdf is missing)

Please find herewith the attached KOBO form and advise me how I will do it.

matrix.xlsx (7.43 KB)

Dear @stephanealoo

Still Not working value NaN
Can I share my form plz give ur account name

Dear @stephanealoo

Still Not working value NaN
Can I share my form plz give ur account name
plz see my attachment

BSC_Share.xlsx (73.9 KB)

Dear all

input 1. CIG_Grade then result show 0

When I select 2. CIG_20 then 1. CIG_Grade not displayed.
input 2. CIG_20 then result show 0

I need any of one group result.

Try using coalesce in row 46 as shown below:

coalesce(\${NQ1},0) + coalesce(\${NQ2},0) + coalesce(\${NQ3},0) + coalesce(\${NQ4},0) + coalesce(\${NQ5},0) + coalesce(\${NQ6},0) + coalesce(\${NQ7},0) + coalesce(\${NQ8},0) + coalesce(\${NQ9},0) + coalesce(\${NQ10},0) + coalesce(\${NQ11},0) + coalesce(\${NQ12},0) + coalesce(\${NQ13},0) + coalesce(\${NQ14},0) + coalesce(\${NQ15},0) + coalesce(\${NQ16},0)

My problem is 91 row plz see that

Instead of creating a single variable `(if(\${calculation_003_001}=’’,0,\${calculation_003_001}))+(if(\${calculation_003}=’’,0,\${calculation_003}))` for this in `row 91` would you mind creating 2 variables viz. `if(\${calculation_003_001}=’’,0,\${calculation_003_001})` and `if(\${calculation_003}=’’,0,\${calculation_003})` and then make a third variable adding the values from the variables above. It should solve your issue.

If \${a}=2 then \${b} is greater or equal to 2009 and less than or Equal to 2016
If \${a}=1 then \${b} is greater or equal to 2017 and less than or Equal to 2020

What is the statement for that which I want to put in the Validation Criteria