https://bugs.documentfoundation.org/show_bug.cgi?id=141590
Winfried Donkers (retired) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Resolution|--- |NOTABUG --- Comment #13 from Winfried Donkers (retired) <[email protected]> --- Using attachment 171099 and formula =FORECAST.ETS.PI.ADD(C40;D13:D40;C13:C400;1) from comment#11 problem is clear: the first given argument (target) is part of the data given to calculate the forecast from. That is impossible, you cannot forecast a value that is given. When you add in C41 a date (say 2022-03-01) and change the first argument from C40 to C41, you get a result. In this case 0 because the data given do not show any variation, making the use of exponential triple smoothing (ETS) forecast functions useless. When there are no periodic influences, standard forecast functions will suffice, when there is no variation at all, forecast functions are not needed. Note: the last given argument (confidence level 1) is not realistic. This is a forecast function and 100% reliability is not achievable, unless the data set is such that forecasting functions are not needed (as is the case in this attachment); -- You are receiving this mail because: You are the assignee for the bug.
