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:

=(Fields!new_afstand.Value*Fields!new_kilometervergoeding.Value)+Fields!new_kostenvoorbereidingaccount.Value+Fields!new_kostentrainingaccount.Value+Fields!new_kostenoverigeaccount.Value+Fields!new_kostenoverigeaccount2.Value+Fields!new_kostenoverigeaccount3.Value

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(Formula)

- =Sum(km*cost/km) + Sum(Preperation cost + Sum(Project Cost) + Sum(MultipleOtherCosts)

- =Sum(ReportItems!textbox2.Value)

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?

Thank

**View Complete Post**

## Group Total in Footer (SSRS)

Hello,

I am using SSRS and have a group named "G_Invoice" . In the footer I need to total the group's total. I used the following lines

=Sum( Fields!InvoiceAmount.Value ,"G_Invoice") in the textbox .

I also tried

=RunningValue(Fields!InvoiceAmount.Value ,sum,"G_Invoice")

In both the cases, it shows an error

The Value expression for the textbox ‘textbox27’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.How to achieve it

?Thanx