Hi, I've created a calculation that counts how many problems are solved. * - Problems are first selected from a multiple selection question. Every problem, if selected is =1 in a hidden question. the sum of all of them gives me the "Problem = number" * When the problem is selected a question: "it has been solved" comes up: if answered yes, an hidden question collects =1 and they are summed up. Solved = number * A calculation Problems - Solved = to be fixed * this I know how many problems I have, how many fixed or not It works perfectly if all my 3 problems are selected, if I select only one or two the calculation doesn't work: solved and to be fixed are empty. this is a repeat table. By default all values are set to 0 {es.= if(selected(${Problem},'Choice_1'),1,0)}, can't understand why the value Solved and To be fixed is empty Thanks!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help in Calculating Difference when a multiple selection is involved

PanGIS

Hi,

I've created a calculation that counts how many problems are solved.

- Problems are first selected from a multiple selection question. Every problem, if selected is =1 in a hidden question. the sum of all of them gives me the "Problem = number"
When the problem is selected a question: "it has been solved" comes up: if answered yes, an hidden question collects =1 and they are summed up. Solved = number
A calculation Problems - Solved = to be fixed
this I know how many problems I have, how many fixed or not

It works perfectly if all my 3 problems are selected, if I select only one or two the calculation doesn't work: solved and to be fixed are empty.

this is a repeat table. By default all values are set to 0 {es.= if(selected(${Problem},'Choice_1'),1,0)}, can't understand why the value Solved and To be fixed is empty

Thanks!

Trouver plus de publications taguées avec

Accepted answers

dougbrowning

That makes more sense but it still wont work.

It is because all select one must be string. So even though you give it a 0 and 1 it is really "0" and "1". 123 tries to help you when all three are filled out and gifts you the conversion. This will prob not work at all on the web.

Best thing is to make a second set of if(value, 1, 0) and then count those just like you do for Choice_T. I think it is the best way. int("") is what is causing the non calc.

Other option that may work is to use coalesce("", 0) and put that inside the int. Then it should give you 0 if it is sitting on blank.

Hope that helps

All comments

PanGIS

@DougBrowning

I set all binds to int, and I fixed that calculation but still...same as before

I uploaded here the updated XLS, in case you have time to see it again.
Thank you for the hint. I have always overlooked that bind.

Test_Un_Solved_Community.xlsx

dougbrowning

I did not get a chance to test but I bet it is the bind.

For your 3 hidden counts like Choice1_T set the bind::type to int. That way it is treated as a int in the form. I know you have the esri bind there but that really just sets the service field and does not set the type while in the form.

I also see you use int later on most of them but you missed...

count_Problems try setting that field bind type to int also.

So right here ${count_Problems} - int(${count_Problems_Solved}) count _problems is still a string.

I think that should do it.

It is easier to just set the bind column vs using int all the time. Hope that does it.

PanGIS

@DougBrowning

all the calculations are inside the repeat.

This is my sample.

Thank you!

Test_Un_Solved_Community.xlsx

dougbrowning

My guess is you have {es.= if(selected(${Problem},'Choice_1'),1,0)}, outside the repeat. Would help to see the form.

nabaz-gharib

One way to fix that is to add two calculated fields (hidden) after each choices, one if the option is yes and one if no . for each answer set corresponding field to 1, then add a sum for each value solved yes or no. then you can use the sum fields for the label.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.