Hello, I have a report that is a recap for grades of steel. For each grade group one of the fields is a fomula of costs for that grade. The running totals that make up the formula resest on group/grade change and wrok fine. I also have a report total for all the grades sold in teh month of the report. The report total costs are also working fine. Now for the issue, the user would like to see a field for each grade that shows % of total cost. Basically what I have done is a formula field that says (@GradeCost/@TotalCost) * 100. Problem is @TotalCost is being evaulated at the same time as @GradeCost, so for the first Grade/Group on the report it shows that the grade is 100% of total costs. When I do the math myself looking at the cost it should be 2.3 %, hence the issue. I have tried coding my CosPct formula as follows but still get the same thing. Any ideas how to get the TotalCosts to have the report value before the grade group is created?
EvaluateAfter({@TotalCost});
(@GradeCost/@TotalCost) * 100