Hello Everyone.
I have a graph that is showing sales per year in the last 5 years. The sales dropped in 2022, clearly, because the year in not over. I would like to project the rest of the years in the graph. How could I do that? is there any function?
What I mean is, lets say that I sold 10 euros from the 01.01.2022 to today. 263 has passed since 01.01.2022, so at the end of the year I would have (102/365)*10=2,8... so I would have 12,8 euros at the end of the year.
Greetings