@ChristopherWood - you have not defined how the Risk Rating should be calculated based on the sum of the Likelihood and Impact Scores.
There are many ways to achieve what you're trying to do. Here is one way:
Create a Collection which maps out what the rating should be per score (or ideally create a new table in your data source with this mapping, then load the table into your app):
ClearCollect(
col_ratings_map,
Table(
{
Score: 2,
Rating: "Low"
},
{
Score: 3,
Rating: "Low"
},
{
Score: 4,
Rating: "Medium"
},
{
Score: 5,
Rating: "Medium"
},
{
Score: 6,
Rating: "Medium"
},
{
Score: 7,
Rating: "Medium"
},
{
Score: 8,
Rating: "High"
},
{
Score: 9,
Rating: "High"
},
{
Score: 10,
Rating: "High"
}
)
)
Assuming you are indeed using Dropdown controls and not ComboBox controls, I assume the Items property contains numbers. E.g.:
[
1,
2,
3,
4,
5
]
On the Default property of the Risk Rating Dropdown control, enter:
With(
{
sum_selected: Sum(
DropdownL.Selected.Value,
DropdownC.Selected.Value
)
},
LookUp(
col_ratings_map,
Score = sum_selected,
Rating
)
)
