6 Replies Latest reply on Oct 3, 2018 5:53 AM by madhuri.tanniru

    Conditional sum in a running window

    madhuri.tanniru

      Hi,

       

      I have the following dataset

       

       

      With "Dev Status ID Parameter" set to 1 and "Date Paramter' set to 2018-9-30

       

      1. In the month of August, the calculation should be = 7/ 7 = 100%

       

      2. In the month of September, the calculation should lead to : 7/7, where for employee "AS", the value to be considered is the value entered on 09/24 and not the one listed on 08/28  and the rest of the data points are valid as of September 2018-09-30

       

      Thanks