Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try simply:
Column(2) / Column(1)
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
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
Ciao Marco try with:
(Column(1) - Column(2)) / Column(1)
let me know
try
it should be (Column(1) - Column(2) ) / Column(1)
Thanks now it works!!
Marco