I have a form that I would like to calculate a qualitative risk score but cannot seem to do so. I have one field "Risk Impact" and another field "Risk Probability" I would like to average these two fields in a third field "Risk Score" The values for each of the source fields will always be 1-5. No matter how I write the expression now, I get the total average for all records of the source field. I would like each row to show the average for only the fields in that row and not a total.
Any tips?