Percentage Computation

[marco_puccetti]

Hello i need to compute in a table the percentage of increase\decrease from 2 date related to two years. In this case i have these datas:

Column 1   Column 2    Delta %

    4                 4              0%

The formula i have used is this: Column(1) - Column(2) / Column(1)

but it returns me 300%.

If i insert the single datas, in the column it returns the correct data.

Can you explain why or to solve it?

Thanks

[Anonymous]

Try simply:

     Column(2) / Column(1)

[sunny_talwar]

Shouldn't it be Column(2)/Column(1) - 1? But this would give the same result as above, no??

Is it possible to share a sample application where you see this behavior?

Best,

Sunny

[jsanchezh]

Hello,

I think you left a pair of parentheses out of your expression so, what you are doing is (for example 300% case)

     1) Column(1) --> 4

     2) Column(2)/Column(1) ---> 1

     3) 4-1= 3

Your expression should be:     (Column(1) - Column(2)) / Column(1)

Greetings

[alexandros17 · Accepted solution]

Ciao Marco try with:

(Column(1) - Column(2)) / Column(1)

let me know

[manojkulkarni]

try

it should be (Column(1) - Column(2) ) / Column(1)

[marco_puccetti]

Thanks now it works!!

Marco