4 Replies Latest reply: Jun 14, 2017 2:33 AM by Pankaj Thakur RSS

    How to use "if" and compare it with the calculated data in a different column

    Agilan Swamy

      I have the below data

       

      GradeNameMoney1 (Will not change)Money2Category
      AVice President1000011000(if variance% between money1 & 2 is <20%, then show the value)
      BDelivery Head1500013000(if variance% between money1 & 2 is <20%, then show the value)
      COperations Manager1800019000(if variance% between money1 & 2 is <20%, then show the value)

       

      The column Money1 will not change, the column money 2 will be picked up from the raw data and compared against the column "Grade".

      I want to calculate if variance% between money1 & 2 is <20% for each of the grade and then the category should the value %)