I'm looking to implement requirement as below. We need to calculate severity based on options selected in 4 different fields.
These are the drop down values for all the fields(multiselect).
Functional Impact:
Value 1, 2, 3, 4
Workaround Available:
Value 1, 2, 3, 4
Financial Impact:
Value 1, 2, 3, 4
External Impact:
value 1, 2 , 3, 4
If functional Impact is value 1, Workaround is value 2, Financial Impact is value 2 and External Impact is value 3 then Calculated Severity = Low
If functional Impact is value 3, Workaround is value 2, Financial Impact is value 4 and External Impact is value 4 then Calculated Severity = High
And so on..
There are multiple conditions like those that we are looking to satisfy.
Hence, selecting values for 4 different fields should write one field (calculated severity with 4 options - low, medium, high, severe) and be readonly. It should change as per the options selected in the above fields.
The drop down values of Functional Impact, Workaround, Financial Impact, External Impact are not dependent on each other and are static values. But depending on what is selected for these 4 fields, the severity field should display a value.
Have you had any scenarios implemented like this before? Any help around helping us implement this business logic would be great.