SSRS 2008 sub total and Grand total not adding up correct

Question

i am new in this forum and newbie on SSRS 2008, have created report ,3 level of total ,

1 level total by asset by expression used by Max(Fields!ACQUISITIONPRICE.Value)

2 level by Fixed asset by group expression =Sum(Fields!ACQUISITIONPRICE.Value) this not adding correct either, because the ASSET ID total I used as Max so its not giving me correct me correct total

3 level is Grand total all the asset , this total is not coming correct , its adding up all acuistion price in column was hidden , I just want to add only what's in the total by asset id

can any one please help me with this, I have been working on this for while, have not figure this out yet,

I really need help, thanks in advance

would like to reopen this issue, its not resolve, new to this form, — user3433460

JC Ford JC Ford · Accepted Answer · 2014-03-18T19:30:29

Try something like this:

=Sum(Max(Fields!ACQUISITIONPRICE.Value,"NameOfGroupHere"))

Where "NameOfGroupHere" is the name of the innermost group defined in your table.

SSRS 2008 sub total and Grand total not adding up correct

1 Answers