I’m trying to create a forecast model where we start, for example at $1000 in period 1, which grows at $250 every period. The growth is cumulative, so I’m unsure how to create this.
Welcome to the community, @Amir_Banihashemi! Your question doesn’t contain enough detail to effectively allow us to help. Is your base already designed? If so, please describe the relevant fields that would play into the calculation. Also please describe how you envision this working day-to-day (or period-to-period as the case may be). How much of this is manually driven? How much is automated? For the automated pieces, what needs to trigger the automation?
Long story short, the more detail that you can provide, the easier it will be to assist.