topic Paginated report showing incorrect % at grand total level, in Report Server

Paginated report showing incorrect % at grand total level,

Darshan_hello — Thu, 27 Jun 2024 17:05:30 GMT

Hi,

We are getting the incorrect % at pagianted report wherever we used % related inforamtion, i have attached the screenshot from Both power BI and Pagianted report. requesting to look and give the solution for this, we have tried to use both SUM and SUMX for Actual/Budget but still getting the incorrect numbers at grand total level.

Sample data

Product Name	Actual Value	Budget Value
Sedan	361727	350087
Aura	55952	32679
City	193995	122164
Verna	111780	195244
Total	361727	350087

-Darshan

Re: Paginated report showing incorrect % at grand total level,

Darshan_hello — Thu, 27 Jun 2024 17:06:10 GMT

Hi Experts, Please provide the solution for the above issue,

Re: Paginated report showing incorrect % at grand total level,

Anonymous — Fri, 28 Jun 2024 09:21:35 GMT

Hi, Darshan_hello

Based on your description, I've used the instance data you provided and built a custom column to calculate the percentages:

Create a matrix in Report builder as follows:

=Sum(Fields!ActualValue.Value)/Sum(Fields!BudgetValue.Value)

Here are the results:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.