Perform Calculation in a matrix
I have a SSRS 2008 and have a matrix with Calendar_Month as a column name, StatusName as a row name and Sum(TRANS_AMT) in the details section. There are four StatusName values from my stored procedure which include Invoice, Check, Void Check and Discount
with dollar amounts for each. What I want to do is to create another row of data in this matrix which give a percentage of Void Checks to overall checks (=Void Check/Check). What is the best way to do this?
Thanks,
ChuckChuck W
May 16th, 2012 4:23pm
Hi There
Please right click on your column group of matrix and insert column outside group right and put expression something like this
=iif(Fields!StatusName.Value = "Check" And Fields!TRANS_AMT.Value = 0
Or Fields!TRANS_AMT.Value Is Nothing, 0,
(Sum(iif(Fields!StatusName.Value = "Void Check", Fields!TRANS_AMT.Value, 0))
/ iif(Sum(iif(Fields!StatusName.Value = "Check", Fields!TRANS_AMT.Value, 0)) = 0, 1,
Sum(iif(Fields!StatusName.Value = "Check", Fields!TRANS_AMT.Value, 0)))))
Please set the format of that textbox as percentage by right clicking on it go to properties and number and set a percentage
I have put some screenshot for your help
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 5:02pm