wrong percent value in straight tbl

[surajap123]

Hi All,

I have the below three expressions in the straight table.

=(sum({<Year={$(=Max(Year))}>}ATotal)+ sum({<Year={$(=Max(Year))}>}STotal))/1000  //show value in thousands

=(sum({<Year={$(=Max(Year)-1)}>}ATotal)+ sum({<Year={$(=Max(Year)-1)}>}STotal))/1000  //show value in thousands

=(Column(2) - Column(3)) / Column(2)

-the first one is to show YTD Sales for current year.

-the second one shows YTD sales for previous year

-the third one is to show the YTD Variance.

=For the third expression i have done percentage settings (ie. Number tab--> fixed to 1 and enabled 'show in percentage'.

But, if you see the screen shot below, few percent value are above 100%, which seems wrong.

Please let me where i am doing wrong.

[jonathandienst · Accepted solution]

Hi

Looks like its working properly to me. Look at the last line. Your variance expression is:

     (7 - 244) / 7   =   -237/7   ~     -3000%

HTH

Jonathan

[jonathandienst]

Perhaps you meant to calculate (244 - 7) / 244?

[surajap123]

I was confused with the results initially. You are right, the result are correct. Thanks...