I have a formula in the attached workbook to calculate the change in rank from the previous year, however the calculation is not working correctly. Could someone take a look and see if they can figure out the issue?
Remove the change pill from the view. Add it again. Click on that pill > choose edit table calc > compute using advanced and move the fields from partitioning to addressing and make sure its set up this way: