Greetings,
Here is my problem. I have a large custom list and most all of the responses are set as pull downs. The three responses are as follows:
1 Negative/Adverse Impact
2 Neutral Impact
3 Positive Benificial Impact
I need to convert these items into something that can be averaged. I realize that I could just put them in as straight numbers and that would do it but im afraid this would cause confusion for my users. My question is this could I use something like and IF THEN ELSE here? I am NOT a programmer and am way outside of my depth but I would picture it to be something like this
What I would need to do then is take all of those numerical values and create an Average calculation on them.
I hope this makes sense and I look forward to your response
Thanks
Anything worth doing is worth messing up at least 5 times before you get it right!
Here is my problem. I have a large custom list and most all of the responses are set as pull downs. The three responses are as follows:
1 Negative/Adverse Impact
2 Neutral Impact
3 Positive Benificial Impact
I need to convert these items into something that can be averaged. I realize that I could just put them in as straight numbers and that would do it but im afraid this would cause confusion for my users. My question is this could I use something like and IF THEN ELSE here? I am NOT a programmer and am way outside of my depth but I would picture it to be something like this
Code:
If {field name} = 1 Negative/Adverse Impact THEN 1 ELSE
IF 2 Neutral Impact THEN 2 ELSE
3 Positive Impact THEN 3
I hope this makes sense and I look forward to your response
Thanks
Anything worth doing is worth messing up at least 5 times before you get it right!