Summation not working as expected

Dane Thomas 21 Reputation points
2021-08-25T13:39:03.967+00:00

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?

126338-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,831 questions
0 comments No comments
{count} votes

Accepted answer
  1. Isabellaz-1451 3,616 Reputation points
    2021-08-26T02:31:02.55+00:00

    Hi, @Dane Thomas ,

    I think the issue is probably with your group. I made a demo. You can refer to my grouping. Please check the Row groups in the lower left corner of the design report. (If you can’t see the details, please open the column groups -> Advanced Mode)
    Make sure that your total row is in the group Customer and has a parallel relationship with Details.
    If it doesn’t work,Please take a screenshot of your detailed table design, so that I can reproduce your issue.

    126546-%E8%AE%BE%E8%AE%A1%E5%9B%BE.png

    126562-%E9%A2%84%E8%A7%88.png
    Best Regards,
    Isabella


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Dane Thomas 21 Reputation points
    2021-08-31T20:36:38.683+00:00

    I was able to correct the totals with the fix you suggested. I am now running into another issue. When verify the detail in my report it appears that the quanitities and the extended price the items I've sampled have been multiplied by 3. For example, when looking at the order in the top row of the screen shot below, the quantity should be 1 and the ext price $322 and change. Do you know what might be causing this. Sorry, I am new to this :o

    128028-image.png