Multi-row Formula calculation

[stanleyfeng2024]

I am trying to use multi-row Formula tool to calculate the diff (subtract prior month from current month) in a new column and calc the % of change. But it give me 0, something not right. Can anyone help? Thanks. 

               QTY     Change   %
8/1/2023 50,000      0
9/1/2023 35,000      0
10/1/2022 2,548      0
3/1/2024 58,426      0
5/1/2024 25,168      0
1/1/2023 33,258      0
1/1/2022 25,163      0
4/1/2023 26,147      0

[stanleyfeng2024]

Sorry, should have sorted the date

[Bren_Spill · Accepted solution]

@stanleyfeng2024 - see attached. Thanks

[albert_alaluf · Accepted solution]

Hi @stanleyfeng2024 

Please see here. I believe you just missed the data type conversion.

Please let me know if this is what you're looking for.

Albert

[stanleyfeng2024]

Thanks both @albert_alaluf and @Bren_Spill