6 Replies Latest reply: Dec 15, 2016 2:25 AM by Shraddha Gajare RSS

    Percentage formatting

    Dhanashri Dindore

      hi,

       

      i have table as follows:

      order value1
      order value 2total_sales_value
      15087

      505

      6499600
      8145700

       

       

      and i am getting output like:

       

      sales %
      469.3
      271.6
      180

       

      i am using formula as - (order value1+order value2)/total_sales_value*100

      here i am getting percentage format as shown in table i.e 469.3% using 12.3% number formatting also using 12% number formatting ans is - 469%.

      but actual expected ans is 46.93%

       

      how to solve this condition?