5 Replies Latest reply on Sep 13, 2018 3:36 AM by Vijay Oswalia

    Rounding issue occurring while dividing the values

    Vijay Oswalia

      Hello,

       

      My issue is that when I do " [2018 weightage]-[2017 weightage ]/ [2017 weightage]" then all my values get rounded upto -1 but "[2018 weightage]-[2017 weightage]" gives the correct  result.I have Views of years 2018 & 2017 then I have calculate the weightage of each view with respect to the sum of all views of that year. Now when I am trying to find the progress from 2017 to 2018 using " [2018 weightage]-[2017 weightage ]/ [2017 weightage]", it is giving me only -1.00 instead of -.7/6 something. I have attached the workbook.

       

      Thanks and greets,

      Vijay

       

      Message was edited by: Vijay Oswalia