Paginated report showing incorrect % at grand total level,

[Darshan_hello]

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

[v-jianpeng-msft · Accepted solution]

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.

[Darshan_hello]

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