Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate severity based on options selected in 4 different fields(Multiselect Fields)

Divyakiran singhvi June 24, 2019

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.

0 answers

Suggest an answer

Log in or Sign up to answer