I'm trying to develop an assessment, but I'm not the brightest bulb of the bunch. The way I have it written, it lists the score values I've tried to assign instead of adding them together (e.g., instead of adding 3 "1"s together, it lists them as "111" instead of "3"). Any help is appreciated.
Accepted Solutions
EDIT: I made a few notes here as I was going through the XLSX (attached).
This is fine as-is because you are using count-selected() on its own. It's just the nature of count-selected() to give you the result you are looking for. But, if you combine this with other calculates you will likely run into issues:
This one wont work because you wrapped the entire end result in int(). Essentially, you are converting your string of separate numbers (e.g., 111 vs 3) into an integer. If you want this to work, each individual item needs its own int() (e.g., int(${field1}) + int(${field2}):
You use a lot of type hidden fields. This is not recommended:
The better approach is to select the appropriate data type (e.g., Integer) and then make the appearance hidden:
Because your IF statements use "null", you are adding stuff that shouldn't be added, meaning you may end up with this in some cases (NaN = Not a Number):
Looking at your formula, it may make more sense to swap a few things up.For example, most of your "hidden" fields should b calculates.
I also noticed you were missing your constraints for the spinners. This is how they should appear:
For future reference: calculates do not require a label, and notes do not require a name.
I have made some edits to the XLSX. I am not saying that it is perfect, but it should put you into the right direction (and all of your calculate fields at the end are working).
@DougBrowningis correct. This is definitely a case of text fields being used for math.
Here is a visual idea of that he is describing. Note the use of the bind::type column:
Which results in my_field2 properly adding my_field (e.g., 32+5+7=44) rather than combining fields (e.g., 32+5+7=3257) like you are seeing:
(note that this example is a very sub-optimal set-up for the purposes of an example. Typically, you wouldn't use a "text" field like this)
EDIT: I made a few notes here as I was going through the XLSX (attached).
This is fine as-is because you are using count-selected() on its own. It's just the nature of count-selected() to give you the result you are looking for. But, if you combine this with other calculates you will likely run into issues:
This one wont work because you wrapped the entire end result in int(). Essentially, you are converting your string of separate numbers (e.g., 111 vs 3) into an integer. If you want this to work, each individual item needs its own int() (e.g., int(${field1}) + int(${field2}):
You use a lot of type hidden fields. This is not recommended:
The better approach is to select the appropriate data type (e.g., Integer) and then make the appearance hidden:
Because your IF statements use "null", you are adding stuff that shouldn't be added, meaning you may end up with this in some cases (NaN = Not a Number):
Looking at your formula, it may make more sense to swap a few things up.For example, most of your "hidden" fields should b calculates.
I also noticed you were missing your constraints for the spinners. This is how they should appear:
For future reference: calculates do not require a label, and notes do not require a name.
I have made some edits to the XLSX. I am not saying that it is perfect, but it should put you into the right direction (and all of your calculate fields at the end are working).
