On the screen shot below, I am trying to sum Ext Price on the Customer level and a grand total on the location ID level. On the detail, I have the formula as Fields!Quantity.Value Fields!UnitPrice.Value...easy enough. However, when I am trying to sum these I am getting wrong values. The formula I am using is what I thought I have been using on other reports which is sum(Fields!Quantity.Value Fields!UnitPrice.Value). Am I missing something?



