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

    Conditional sum in a running window




      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