I have created my survey in Connect and uploaded it to the online portal. The survey allows users to score competition submissions based on our criteria. These criteria need to be weighted, so I created a hidden question that is used to calculate the weighted score at the end. The calculation is as follows:
(${multigenerational_living}*.25)+(${universal_design}*.25)+(${housing_affordability}*.2)+(${environmental_sustainability}*.1)+(${infill_development}*.1)+(${modularity}*.05)+(${cultural_character}*.05)
Criteria can be scored 0-5.
The issue is that for some combinations of scores, the Weighted Score Total shows multiple extra decimal places that shouldn't be there:
Strangely, if I download the file as a CSV or Excel document, those decimals are gone, and the correct score shows (see attachment). I've also tried taking off different weights and adding them back into the calculation - it seems like it works fine if there are 5-6 weights added but then messes up again when the sixth or seventh is added.
I've attached my xlsx document for the survey, as well. If anyone has any answers, I'd like to know what the issue is.
Accepted Solutions
