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:



      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.


      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.