Real analysts call it percent delta just so you know We use these to show month-over-month MoM and year-over-year YoY changes in data and they should be in every reporting dashboard you build. That is first calculate the difference between the values by subtracting the old value from the new value. New value old value ABS old value.
You sold 5 more paintings this year.
This time we fix the reference to cell B2. From the current month sales subtract the number of sales of the same month from the previous year. Observe the formula B3 which is 450000 from that we subtracted B2 which is 400000 and the difference multiplied with 100 and divide the results with B2 which is base salary 400000. Here is the formula that is commonly used.
