I am creating a pseudo scorecard on a custom form. I have radio button fields that a user will select the answer that best fits the statement.
Example: The project adhered to brand standards Choices: Agree Somewhat Agree Disagree
I have a calculated field set up to "score" the choice selected
IF(The project adhered to brand standards="Agree","2", IF(The project adhered to brand standards="Somewhat Agree","1", IF(The project adhered to brand standards="Disagree","0")))
If a person selects Agree, the statement is scored with a 2 and so on.
My next step is to collect all the assigned "scores" and add them up. This is where I am getting tripped up and looking for suggestions on how to accomplish. I added a calculated field and used the SUM calculation, but nothing shows when the form is filled out. I tried to change the format to number, but that did not seem to work either.
Here are some screenshots of my calculations both for the scoring and the sum of the scores.
I have made sure to take out the punctuation as that was causing an error in my calculations.
Is this possible or am I trying to do something the tool cannot accommodate. Any help/feedback is appreciated.
Here is what I see on the custom form. Joe Benes Brighthouse Financial Charlotte, NC