Select to view content in your preferred language

Help in Calculating Difference when a multiple selection is involved

1936
10
Jump to solution
01-18-2022 07:55 AM
PanGIS
by
Regular Contributor

Hi,

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

  1. - 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" 
  2. 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
  3. A calculation Problems - Solved = to be fixed
  4. 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!

PanGIS_2-1642521257176.png

 

PanGIS_1-1642521219994.png

 

PanGIS_0-1642521177799.png

 

Tags (2)
0 Kudos
10 Replies
DougBrowning
MVP Esteemed Contributor

I think I saw that in there.  It should be this I think.

query allowUpdates=true

0 Kudos