I have different fields with a default weighted value, e.g.:
Likelihood of Success = 10
The user selects a rating for that field from a dropdown list of choices and each rating has a value:
High = 5
Medium = 3
Low = 0
When the user rates the field, I want the app to calculate the total weighted value and populate a field in my SharePoint list:
Likelihood of Success (10), High (3): 10 * 3 = 30
What would that expression look like when the value of the rating varies and the default weighted value does not?
If High, then 5; If Medium, then 3; If Low then 0 * 10
Would I use the data card value in my expression or set some variables and use those?
Solved! Go to Solution.
If you put the Items property of the dropdowns as shown on the right you can set the final score as shown on the lower formula. This formula is the one you can modify to change the weight given to each dropdown's score.
I don't have much to show you, but here is my app:
When they select the rating, the corresponding value of the rating needs to be multiplied by the default weighted value of the topic they were rating. Then that calculated value needs to populate my SharePoint list:
I have the Value fields in my app and they will be hidden, so I can set those values to whatever I calculate. I'm just not really sure how to begin. I set 3 variables OnStart:
VarHigh, 5
VarMed, 3
VarLow, 0
So if a field's value = High, I would use varHigh in the calculation. That's as far as I've gotten, I'm afraid.
If you put the Items property of the dropdowns as shown on the right you can set the final score as shown on the lower formula. This formula is the one you can modify to change the weight given to each dropdown's score.
User | Count |
---|---|
247 | |
106 | |
82 | |
51 | |
43 |