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?