Forum Discussion
HEW
Helper III
4 years agoCalculate deviation% based on first available value
Hi. I am trying to calculate the deviation% from the first available value compared to the last available value in selected period. As you can tell from below matrix, the first row in the mat...
Whitewater100
Solution Sage
4 years agoHi:
Please see file for potential solution.
https://drive.google.com/file/d/12P5xySgf5km2qnBBIn-hYGOrY_0qjafp/view?usp=sharing
HEW
Helper III
4 years agoWhitewater100 Thank you for the solution, which works perfectly in your case - and is just what I need.
My dataset is, unfortunately, not build up with a row per day, but with a date range. F. ex. a purchase price is valid from Oct. 1 2018-Dec. 31 2019. And theres a new prices valid from Jan 1. 2020-current date.
I have tried to convert the date range to a list of dates to have the same layout as your solution, but it wouldn't work due to the amount of data.
Any suggestions how to solve the adjust your solution considering my date ranges?
Thanks a lot in advance.