Forecasting Data for Event Revenue

shecodesit

Hello,

I'm looking for a way to project future event revenue projections in a dashboard. If I had revenue from Q4 and Q1, is there a formula to forecast Q2 data similar to excel? What formulas have you used before?

Thanks!

Paul Newcome

What logic would you use to forecast? Would it be an average of the two, the higher of the two, increase/decrease by the difference? It is possible using formulas, but you would have to determine the logic behind generating the forecast.