Calculate percentage

Question

Dear All Experts,

Please see the snap attached here.  I have desiged one matrix report.

Now my problem is that i cant able to get Percentage automatically instead of that total is coming.

Please see the yellow color highlighted column which i want to achieve.

There are two row group and tow column group.

Row group are 1) branch 2) Name
Column group 1) Type 2) Amount

In type Sales and Collection is coming
and in Amount Group - Amt and target is coming.

I hope you get my requirement.

Please guide me how to do this.

Regards,
AKM

Answer 1

In the matrix the settings to calculate as Percentage

Answer 2

There is not any setting of percentage.

Answer 3

Hi Sqlakm,

We can use custom code to do it. I have tested it on my environment, the steps below are for your reference.

1. Copy the custom code below and paste it to your report. (Right-click report>Report Properties>Code)
   Dim Shared Num1 As Integer
   Dim shared Num2 As Integer
   Public Function GetAmount(Amount as Integer, Type as String) 
   If Type = "Amt" Then
      Num1=Amount
   Else
      Num2=Amount
   End If 
   Return Amount 
   End Function
   Public Function GetPec()
   Return Num1/Num2
   End function
2. And then use the expression to the matrix.
   =Code.GetAmount(Fields!Amount.Value,Fields!Type.Value)
   =code.GetAmount(Sum(Fields!Amount.Value),Fields!Type.Value)
   =Code.GetPec()
   

The report looks like below.

If you have any questions, please feel free to ask.

Regards,

  

---

Charlie Liao
TechNet Community Support