question

DaneThomas-3249 avatar image
0 Votes"
DaneThomas-3249 asked Isabellaz-1451 commented

Summation not working as expected

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
image.png (218.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered ZoeHui-MSFT edited

Hi, @DaneThomas-3249,


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.



设计图.png (17.3 KiB)
预览.png (6.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DaneThomas-3249 avatar image
0 Votes"
DaneThomas-3249 answered Isabellaz-1451 commented

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



image.png (24.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you see the dataset data , it is 1 or 3? you can preview the data In the DatasetProperties -> Query designer

0 Votes 0 ·