I have an application and created a questionnaire/application. I have allowed the users to complete unlimited questionnaires/application records. the outcome of the questionnaire/application record is a Risk Rating.
How do I automate and calculate to get the Highest Risk Rating from the questionnaire/application record?
How do I use calculated field on this? Currently my risk rating is a values list.
How do I select the highest risk rating dynamically? example
Scenario A for ITEM X
Survey Entry A has Risk Rating of Medium
Survey Entry B had Risk Rating of Low
Thus ITEM X will be Risk Rating of Medium
Scenario B for same ITEM X
Survey Entry C has a Risk Rating of High
ITEM X will not be a Risk Rating of High
Most likely you need to have calculated fields and use the logic that get it out