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???
