Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

% per item within a group inside another group

Status
Not open for further replies.

ba4crm

Technical User
Dec 19, 2003
92
US
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?
 
Hi all,
Please disregard this question. I had an early morning "epiphany" and realized all I had to do was insert a summary field! Did that - and it works perfectly!!
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top