10 Replies Latest reply: Aug 23, 2017 7:03 AM by Sunny Talwar RSS

    how to divide the individual column value by its total column value??

    Divyanshi Bansal

      Untitled.png

      I need to calculate the values for the column named %.

      I need the values corresponding to each date values.

      the logic to calculate is Headcount/sum(Headcount)

      Eg. 10/400 for offshore and 5/10 for onsite and so on..corresponding to all the date value.

       

      I m  getting the valid data as per my logic.

      Kindly guide me.