Calculating % 2012 vs 2011

[#1]

I have 2 expressions sum({$<Year={2011}>}[Billed Amount USD]) and sum({$<Year={2012}>}[Billed Amount USD]), how can i calculate the % that expresses 2012 vs 2011?

[jonathandienst]

Hi

The % increase could be expressed:

(sum({$<Year={2012}>}[Billed Amount USD]) - sum({$<Year={2011}>}[Billed Amount USD])) / sum({$<Year={2011}>}[Billed Amount USD])

Hope that helps

Jonathan

PS: Check the display as % option on the number tab of the chart proprties

[#3]

hai,

use (current-previous/current )  and use relative option   in straight table  so you will get the variance.

see the attachment

[#4]

Got it, thanks!