问题描述:

I have two columns 2016 and 2015 representing the years from the Year column. Each of these years has values for example:

The columns(2016 , 2015) are generated dynamically. I want to calculate the percentage by taking value of 2016 and dividing it through the value of 2015. Now the question is, how can I get to the values? I tried to do it through this expression, but It is not working properly.

Expression :

=IIF(Fields!Year.Value="2016",Fields!Amount.Value,0)/

IIF(Fields!Year.Value="2015",Fields!Amount.Value,0)

网友答案:

Try this:

=SUM(IIF(Fields!Year.Value=2016,Fields!Amount.Value,0))/
SUM(IIF(Fields!Year.Value=2015,Fields!Amount.Value,0))

UPDATE:

I've created a matrix to show you the required setup.

Note Prozent is outside the Year column group. It produces:

Let me know if this helps.

相关阅读:
Top