My forecast is forecasting into the negatives :(

%3CLINGO-SUB%20id%3D%22lingo-sub-2648604%22%20slang%3D%22en-US%22%3EMy%20forecast%20is%20forecasting%20into%20the%20negatives%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2648604%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EI%20haven't%20dealt%20with%20this%20situation%20in%20my%20years%2C%20but%20now%20I%20need%20help%20from%20the%20community.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20a%203%20yr.%20forecast%20for%20deal%20counts%2C%20but%20in%20this%20case%20the%20forecast%20plunges%20towards%20the%20negatives%2C%20it%20can't%20be%3C%2FP%3E%3CP%3EI%20have%20the%20seasonality%20on%204%20to%20represent%20the%20quarter%20cycle%2C%20etc.%3C%2FP%3E%3CP%3ECan%20someone%20be%20my%20second%20pair%20of%20eyes%20and%20see%20what%20i%20need%20to%20do%3F%3C%2FP%3E%3CP%3EI%20searched%20online%20and%20some%20say%20to%20use%20the%20solver%20add-in.%20but%20the%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2648604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello everyone,

I haven't dealt with this situation in my years, but now I need help from the community.

I am trying to do a 3 yr. forecast for deal counts, but in this case the forecast plunges towards the negatives, it can't be

I have the seasonality on 4 to represent the quarter cycle, etc.

Can someone be my second pair of eyes and see what i need to do?

I searched online and some say to use the solver add-in. but the 

0 Replies