Hi,
I have a report that has a formula that separates type of applications based on a formula for the ISSCAT.SYM table. Group1 is set to populate from this formula. Group2 has ROOTCAUSE.SYM for each of the entries in Group 1. I am trying to determine what is the percentage for each entry in Group 2 in comparison to the rest of Group1. How would I do that? I found a formula that gives me the correct data, but I am not sure how it works (I need to determine a similar percentage for a slightly different report). Here is the formula:
(Count ({ROOTCAUSE.SYM}, {ROOTCAUSE.SYM}) / Count ({ISSCAT.SYM}, {@Agreement Type})) * 100
Any ideas?
I have a report that has a formula that separates type of applications based on a formula for the ISSCAT.SYM table. Group1 is set to populate from this formula. Group2 has ROOTCAUSE.SYM for each of the entries in Group 1. I am trying to determine what is the percentage for each entry in Group 2 in comparison to the rest of Group1. How would I do that? I found a formula that gives me the correct data, but I am not sure how it works (I need to determine a similar percentage for a slightly different report). Here is the formula:
(Count ({ROOTCAUSE.SYM}, {ROOTCAUSE.SYM}) / Count ({ISSCAT.SYM}, {@Agreement Type})) * 100
Any ideas?