0 Replies Latest reply: Nov 23, 2015 4:57 AM by Juan Carlos Campo RSS

    'Count' between dates

    Juan Carlos Campo

      Hi guys,

       

      For the sample data attached, which labels are:

      censo_empFechaffin_empvalor

       

      where 'censo_emp' is the employee number, 'Fecha' is the employee starting date and 'ffin_emp' the employee finishing date, I need to get the acummulated count of FTE in every month,

       

      " FTE at the Date" must be the accummulated count of the field 'censo_emp' between the minimum 'Fecha' available and every month until the maximum month selected.

       

      Monthfebjunjulagonov
      FTE at the Date41111


      I've been trying with quite a few dataset formulaes for filtering between dates, but I just get the started in every month or the accummulated value repeated in every month.


      Txs you for your help.



      Juan Carlos.