Previous period's value in formula

[Mike_Johnston]

Hello,

I have month end dates and product values. I’m trying to use the previous value in a formula. I started by trying to get the previous month-end date which I was able to get using a DATETIME_PARSE formula. My attempt to get the Previous Value hasn’t worked yet.

In laymen’s language, it would be something like:

Find the Value across the table where Date(in searched records)=Previous Date(in current record) & ProductID(in searched records)=ProductID(in current record)

ProductID is linked to a Products base.

I’m very new to Airtable and appreciative of any help. I tried to include a screenshot but my guess is as this is my first post it won’t let me. If I’m able to I will.

Thanks

[Mohamed_Swella1]

Hi @Mike_Johnston,

Welcome to Airtable Community !

If I understand you correctly, what you are trying to do is not doable in a direct way on Airtable. You cannot compare 2 values in the same field of the same table. However, there are many work arounds. Easiest workaround would be that you create a Linked field, link the 2 values you want to compare, in the other table use either lookup or rollup, and compare the values.

BR,
Mo