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

Can please help?

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

Can please help?

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).

If the post shared did not fulfill your required query, please provide more details so that we could help you out.

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)

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

I have applied … (if(${CIG_Grade}=’’,0,${CIG_Grade}))+(if(${Grade_20}=’’,0,${Grade_20})) or coalesce(${CIG_Grade},0)+coalesce(${Grade_20},0) does not any of these.

I have two groups in the form 1. CIG_Grade 2. Grade_20

When I select 1. CIG_Grade then 2. Grade_20 not displayed.

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)

1 Like

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

Could please help???