3 Replies Latest reply on Aug 22, 2018 5:27 AM by S Kailay

    Non-numerical calculations

    S Kailay

      Hi all,


      Please could you help with the following...


      I have a 100 entities which each has a rating assigned of either Low, Medium-Low, Medium-High or High - any of these ratings can change on a monthly basis.


      What I'm looking to build is a simple monthly tracker which shows the following:

      1. A BAN which shows the total number of changes during the month

      2. A simple table showing the entity that has changed, detailing previous rating, current rating and notch changes (e.g. Low to High = +3 notches, High to Medium-Low = -2 notches)


      Workbook attached with sample data (version 10.5.2).