Not sure if the topic title clarifies my problem correctly but this is what I'm trying to achieve:
I have a simple report, an overview of different projects grouped by accounts. Every project shows the revenue, the costs and the profit.
I want to have a total of all 3 colums, both in group footer as in the table footer. I know how to do a simple Sum(Fields!revenue.Value) but my calculation is a bit more complicated:
Basicly this adds up: Transportation cost (km*cost/km) + Preperation cost + Project Cost + Multiple other costs
The formula itself works perfectly.
Now when I have 3 projects with an account, I want to know the total. I've tried the following:
- =Sum(km*cost/km) + Sum(Preperation cost + Sum(Project Cost) + Sum(MultipleOtherCosts)
But either I get errors, or the total is incorrect because of the multiplication. The problem is I need to mulitplie km*cost/km first and not Sum(km)*Sum(Cost/km) because than the total is incorrect.
Is there someone who sees a solution for my problem?
View Complete Post