How to create Percentage Column in Reporting Services

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

antonela Ten Centuries Points: 1007 More actions · Answer 1

Do you mean add a column with this values?

London 43,22

Rome 34,83

France 21,93 ?

tt-615680 SSCertifiable Points: 7835 More actions · Answer 2

antonela (4/21/2012)
Do you mean add a column with this values?
London 43,22
Rome 34,83
France 21,93 ?

Thank you for your reply!

No, I mean how do I write the expression inorder to workout the percentage e.g (value/total) * 100

Thank you!

antonela Ten Centuries Points: 1007 More actions · Answer 3

Try this:

Fields!Total.Value/Reportitems!Totale.Value*100

CountryTotal Percentage

London 67 43

Rome 54 ...

France 34 ...

Totale 155