2 Replies Latest reply on Jan 9, 2019 2:42 AM by Kamin Au

    Blend dates between different tabs to calculate ratios? Please help!

    Kamin Au

      Hi,

       

      Have been stuck on this for a while, and just can't figure it out, would appreciate some help on this.

       

      Every month we pull total headcount data so that is point in time. i want to create a chart where we show that the average headcount in year 2016 was 219, and in that year 143 reports were published. Therefore the ratio of reports per employee was 143 reports / 219 employees = 0.65 reports per employee that year.

       

      If i need to blend the dates, i don't know how to do it, so asking that you kindly show me in the attached file. Sorry i'm fairly new to this!