Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, December 6, 2011 6:14 PM
I have created a list that we are using for individual scoring purposes. The list currently uses multiple questions, each with a number input to generate total points achieved. We are now looking to change from number input to radio buttons, consisting of Yes, No, and N/A options. Is it possible to assign values to those options so that the calculated column could produce either a fraction or percentage output? If so, what might example settings/formulas look like?
All replies (3)
Tuesday, December 6, 2011 9:36 PM âś…Answered
Hi
yes you can, but only if you let value to N/A also (-1 )
create a new calculated column, in which you will calculate based on option column value like
if(your_col="yes",6,if(your_col="no",0,-1))
A post with functions you can use in calculated columns
Romeo Donca
Tuesday, December 6, 2011 7:59 PM
Hi
first
your column should be a choice type column with 3 values:yes,no,NA
Second It's really difficult to calculate/ponderate answers like yes or not, beacause that's deppend on the question
I give oyu an ex:
Let's say that your question:
Do you whish that your day-work program/schedule will be from 1. of januar until 10 pm o'clock?"
The users will have 3 answers Yes/No/NA
Let's suppose that 5 of them will answer with yes
5 with no
5 with NA
How can you use these anwers togheter? You can't
The only way is to obtain percent values
Like
Count(column with answers='yes') / count (answers)
you will have which percent of users will like to work until 10 pm
... and so on
An extreme version
put value to YEs=3, No=2 and NA=1, use formula like
( 3 x count( answers='yes') + 2x (answers='no') + 1x(answers='NA')/count (answers)
You will obtain an absolute value, which will be very dificult to make a logical definition -what represent this value
This formula can be done through xslt code in a page, where you want to display your results
Romeo Donca
Tuesday, December 6, 2011 8:42 PM
This is a little different that what I was looking for. I apologize, I should have been more thorough in my description, whether or not what i'm looking for is possible is still questionable.
I am using a list with set questions ranking an individual according to scoring guidelines.
Example columns Example Scores
Answered customers question - Yes = 5, No = 0, N/A = customer did not present question.
Handles objections/complaints - Yes = 6, No = 0, N/A = customer did not have objections/complaints.
In this situation, the perfect score could be 11/11, 6/6, 5/5, or 0/0.
Using this understanding, is it possible to use radio buttons (Yes, No, N/A) as the input for each new item in a list, and to give those buttons each a specific value that a formula could sum and determine the points scored / points possible.