Hi all,

Looking for some help, as I am struggling to get an answer that works.

Example:
- I have a number of items listed (currently 70 line items) with a scoring system attached to each line (1.00-3.50)
- from these line items, certain items will be picked throughout the year and I need to create a measuring system to understand the risk associated with them.

- Anything between 1.00-2.00 will immediately raise a red flag and overrides all remaining rules.
- if I then split the remaining items in 0.50. If 2 items from 2.00-2.50 are picked then a red flag is raised. If 3 items from 2.50-3.00 then a red flag raised. If 4 items picked from 3.00-3.50 then a red flag raised.

- if the total number of items between 2.00-3.50 equates to 6 and the above flags aren’t raised, then a red flag is raised as the risk of these items is over then defined threshold.

How exactly would I build this? Getting confused and falling short somewhere!