Forum Discussion
Calculated Column Filter
How is this approach supposed to help you with income projection?
You can plot your existing data and then in the analytics section choose a forecast line.
Alternatively, pick an extrapolation formula and apply it. Predicting one month from the performance of another mont will be rather crude - you will want to consider seasonality too (ie you want to include the same month last year in your formula)
Thank you for your reply. The projection is a very crude one and makes assumption that in the following months, the expected income is equal to the average of the past data. Therefore the constant value - yes it is indeed not a very accurate one due to the big uncertainties in the business.
Anyway I have managed to resolve this by creating a new table to put all data into a single table. Thank you.