Forum Discussion
TheYellow
May 16, 2024Copper Contributor
Unexpected results
Hello there, first I tried the calculation on SQL Server, and as I wasn't getting the expected results, I've decided to try it on Excel. Interesting enough I got the same results. What am I doing wro...
TheYellow
May 17, 2024Copper Contributor
Sorry for the lack of information!
So it starts with the Column1 and then it calculates the next value adding the percentage of the Diff column, based on the previous Column1. Adding or subtracting. For the 5 initial rows, everything works as expected, but then I start getting unexpected results, at least for my understanding. I first tried this o SQL Server, but as I was getting these results, I tried on Excel, with the seme unexpected values.
So it starts with the Column1 and then it calculates the next value adding the percentage of the Diff column, based on the previous Column1. Adding or subtracting. For the 5 initial rows, everything works as expected, but then I start getting unexpected results, at least for my understanding. I first tried this o SQL Server, but as I was getting these results, I tried on Excel, with the seme unexpected values.
HansVogelaar
May 17, 2024MVP
OK, but you haven't told me in detail how you want the calculation to work, nor how the result is different from what you expected/wanted. That makes it impossible to help you...