Formula calculations based on pulses within the same columns

I haven’t seen a way where we can create a formula where the same column is used for both pieces of the formula because the pulses create the different values.
Ex- our columns record items we sell and our pulses are for the monthly sales amount. Pulse 1 is Jan 2020 we sold 40 units. Pulse 2 is Feb 2020 we sold 45 units.
We want to add a formula column where it will calculate the monthly change between the 2 months and also every month moving forward. Eventually also get qrtly and yearly % change.
As of right now, I do not know how to create this formula, only calculate this difference if the values are in 2 columns not pulses.
Any ideas are greatly appreciated!

hey @Annieo - let’s see how the set up on the board can support this use case.

Could you send us a screenshot of your board that you are using and an example of the result that you would like to see?

Please see attached.
What we want is the MOM % column to auto calculate Feb to March change.
Same with Year over year %

I’m trying to do something similar. Hoping your question is answered.

1 Like

If the two items are linked, you can create a formula that references the numbers in both items.

Once the columns are all working, the links can be updated manually. You could also use an automation/integration to create the new item for next month that would link the columns automatically. Since monday doesn’t allow the use of formulas when using an automation to create a new item, you could use integromat integration to create the new item with the correct name.

Let me know if you have any questions.