All,
I need help with making my XI report look correct. I’m writing a monthly report that display system drug rules for each month and how many time those rules were broken and how many times a person responded and repair the issue. I made the rules display whether or not the rules were broken or not so the data return should be like this:
Rule Broken Response Response_Rate
A 1 1 100%
B 3 1 30%
C 5 4 80%
D 0 0 0%
E 0 0 0%
However, because I’m manipulating the data, I’m getting this instead:
Rule Broken Response Response_Rate
A 1 1 100%
A 0 0 0%
B 3 1 30%
B 0 0 0%
C 5 4 80%
C 0 0 0%
D 0 0 0%
E 0 0 0%
So I’m getting 0s for Rules that already have counts. I want to group the rules together where the Rule are identical but I can’t seem to do it because all the other columns are not the same. BO XI won’t add up the values. Is there a way I can do this?
vxp8602 (BOB member since 2005-03-01)