Hoping someone can assist me with this. I am in need of a way to calculate how many systems are in a lab environment vs a classroom environment, grouped by age and OS. The information in our Database does not contain a specific field for this. I have created a formula that strips part of the name then sorts and counts units based on the revised name of the unit. (e.g XXXRM111-001 becomes RM111 total units 10). From there I need to create groups based on the total number of units in each location - if there are less than 15 then it's classroom more then 15 it is a Lab. Additionally I then need to total each group. I've tried to group based on my formulas but each time I get an error that you cannot group based on a summation formula. I cannot seem to get a running total to work again it appears that the summation is the issue. I would greatly appreciate any assistance you can provide. We are using Crystal Xi.
Ideally I need the output to look something like the following, frill down on each for location of systems would be nice but not necessarily required.
PC units running Windows 7 in a Classroom that are less than 3 years old - #
PC units running Windows 8 in a Classroom that are more than 3 years old - #
PC units running Windows 7 in a Lab that are less than 3 years old --#
MAC units running OS X in a Classroom that are more then 3 years old - #
Etc for multiple OS's and Platforms
Much thanks in advance.
Kevin
