Hi all,
I've created a report that groups records by an equipment class code, then takes the total breakdown costs of each record in the group, totals it for the entire group, and displays the average breakdown costs for that class code group.
The problem that I'm having is once I find the average breakdown costs for the group, I want to take the breakdown costs for each record and devide it by the group average to come up with a percentage for each record. It is making the calculations, but most are not correct because it is calculating the data at the same time.
I realize that crystal calculates in a certain order every time, so I tried playing with creating multiple sections and using "Whileprintingrecords", "whilereadingrecords" and "evaluateafter" in the formulas to no avail. I even tried creating sub-reports both ways (setting and passing the variables to the sub-report and vice versa...)
I am at a complete loss, but I know someone has had a need to do something similar before; I can't be the only crazy person :) ! I really just need some suggestions or ideas as I've just been running in circles the last week or so.
If someone is willing to help me out, I am more than willing to give any details, images and formulas that you need to help me. I'm sure the information that I have given so far is vague since I'm the only person who has spent weeks working on this impossible yet needed report...
Thanks for any help!!!!!!!!!!!!!!!!!!!!!!!!