Hi all,
Can you please suggest how I can construct a formula with SCAN and LAMBDA or any other combination for calculating percentage change by comparing the current month expenses with the previous month expenses, if I have all the values in a single column.
Please check the attached photo.
I would need to get a single array that have as much rows as the column containing the values.
So in my case the last column with the percentage change should be a dynamic array.
Bookmarks