Total of a Multiple Choice Column across Multiple Fields
Hello,
I have a report where each record is a building. The information is broken down to show where region the building is in (there are four regions) and then show the risk of four different areas within a building and assigning a risk level.Users can rate those areas as high, medium, low or complete.
I need to show within a summary report for each region how many of these are high, medium, low or completed. I have tried stacking an If() formula but it currently will override later statements and not produce the correctly totals. I have a formula that looks and summarizes for each record how many have matching values:
Sum(
If([Area1 Risk]="High",1,0),
If([Area 2 Risk]="High",1,0),
If([Area 3 Risk]="High",1,0),
If([Area 4 Risk]="High",1,0))
Is there a way to use this information to help summarize and show the correct totals? Here is what each value should be totaling:
Completed: 94
Low: 66
Medium: 75
High: 49
Total: 284
------------------------------
Sarah Driscoll
------------------------------