How to get percentage Difference

[#1]

hi Everyone. i nee one help.. i calculate a Difference Between Current Year Sale and Last Year

like..

=if(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) > sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount))..

so i m getting and answer Suppose.. This Year sale is 100 Rs and Last Year sale was 50 Rs.. so total growth 50 Rs.. But i want

to show growth in %.. in this case my Revenue growth is 50 %.. because it got double from last year..

Plz help me how to do this

[MayilVahanan]

Hi

Try like this

=if(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) > sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount),

(sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)) / sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount),

(sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount) - sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount)) / sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)

)

Number tab, please check "Show in Percent"

[marcus_sommer]

I would use something like this (simplified without conditions):

sum(CurrentYear) / sum(LastYear)

maybe extended to a 1 - Expressions or reversed or wrapped within a fabs() to display the result from a certain direction.

- Marcus

[#4]

hi Marcus,

on selecting any year ... its need to give current year sale and last year sale and Difference between and Percent Difference between them... can u able to send me the complete expression.. how to write,,..

[CELAMBARASAN]

Actually formula for growth percentage is

((Current Value - Old Value)/Old Value) * 100

So your expression would be

=((sum({$<Year = {$(=max(Year))}>}Price_Pcs_Incl_Discount) - sum({$<Year ={$(=max(Year)-1)}>}Price_Pcs_Incl_Discount))/ sum({$<Year = {$(=max(Year)-1)}>}Price_Pcs_Incl_Discount)) * 100