Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Create forecast table
Best regards to the attentive community. I am looking for an alternative to establish a Forecast that consists simply of increasing the figures in the table by a percentage factor. For this I req...
Syndicate_Admin
3 years agoAdministrator
I appreciate the prompt reply.
I did not know the GENERATE function, it was of great help to expand my table and determine the new date from the VALUE generated by the GENERATESERIES function.
My drawback is now to generate the figures with an iterative year-by-year increment, since the percentages do not accumulate. But I have already come a long way thanks to your contribution.
Best regards.