Forum Discussion

SarahDriscoll1's avatar
SarahDriscoll1
Qrew Trainee
2 years ago

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 area...
JohnRoss3's avatar
JohnRoss3
Qrew Member
2 years ago

Assuming I understand correctly: Is your row grouping currently set to the Risk field, and your column grouping set to Region?  Lastly, does the Risk field include the value complete?  If the Risk field does NOT contain the completed value, I would create a new text formula field that displays the Risk field value, unless the status is completed.  If the status is completed, output "Completed".  This will give you both values in one field.



------------------------------
John Ross
------------------------------