February 27, 2015 at 5:31 am
HI folks,
I need some help desperately. I am very new to report builder 3.0 and have never written in SQL and dont really understand it. I am however comfortable in using the report builder functions to build my reports. However I cannot figure out how to get percentages against the data I have. Using the simple sum(fields)/sum(fields) just causes the results to show as 1. In excel I would usually get the cell to divide by the toal cell - but in report builder the total cells have the same expresion in but the grouping depicts what answer I get.
What expression can I use to get percentages in my tables? I have added pictures of my report and then how it looks when I run it
Any help for a noobie would be gratefully recieved. I feel that once I have an undertsandingn of percentages it will make all my report building significantly easier.
Cheers
Paul
February 27, 2015 at 7:25 am
paul.smith2 (2/27/2015)
HI folks,I need some help desperately. I am very new to report builder 3.0 and have never written in SQL and dont really understand it. I am however comfortable in using the report builder functions to build my reports. However I cannot figure out how to get percentages against the data I have. Using the simple sum(fields)/sum(fields) just causes the results to show as 1. In excel I would usually get the cell to divide by the toal cell - but in report builder the total cells have the same expresion in but the grouping depicts what answer I get.
What expression can I use to get percentages in my tables? I have added pictures of my report and then how it looks when I run it
Any help for a noobie would be gratefully recieved. I feel that once I have an undertsandingn of percentages it will make all my report building significantly easier.
Cheers
Paul
Hi,
Use the following notation, which steps outside of the current dataset group: sum(<fieldname>)/sum(<fieldname>,<dataset>)
Hope the syntax is correct 🙂
February 27, 2015 at 7:26 am
You'd probably get more help in the report forums for this type of question, rather than SSAS, but I'll throw in two cents.
x/x is always going to equal 1 (where x isn't 0). Wouldn't you want something like:
SUM(Fields!ErrorCount.Value) / SUM(Fields!TotalCount.Value)
to get your percentage?
HTH,
Rob
February 27, 2015 at 7:43 am
Thank you so muhc for the responses. I finally managed to figure it but I had to substitute Sum for Count.
Either way the system worked and I am very pleased to have got that sorted. Thank you for the explanations
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply