I am working on a user input controlled klip with value pairs as my component. For some reason only the top value in my screenshot is working when using the user input control.
The user input control variable is column H , the list of countries, called "sustainablecountries"
Each number also needs to be calculated from only active vision centers. This is determined by "true" in column B.
For the top number "Active Vision Centers" - =IF(@B:B="true",1,0)
This contains hidden data @H:H (Country) where the filter is matching "sustainablecountries", and does not match "Country". This is being aggregated by Sum
For "Population Access" =SUMIF(@B:B="true",@K:K)
I set up the hidden data the same exact was as above. Even if I aggregate or turn off aggregation, it simply comes up as 0 when the user input control is used.
For "Local Jobs Created" =SUMIF(@B:B="true"@L:L)
everything the same as above
I am not sure why the top number is working when using the input control but the other values or not. My formulas are not showing any errors.