Forum Discussion

KG1's avatar
KG1
Icon for Resolver I rankResolver I
2 years ago

Completed and Outstanding ID's

Hi

Hoping someone very clever out there can help me 😊

 

The structure of my data is as follows

I need to be able to track the total number of outstanding ID's at the end of the day

 

The output would look like this

 

The total O/S column is calculated by taking the previous days total outstanding and minusing the total 3rd stage approved for that day.

 

I hope this makes sense.

 

 

Need Help

2 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    2 years ago

    Can you please provide some textual data and a clear example ?

    • KG1's avatar
      KG1
      Icon for Resolver I rankResolver I
      2 years ago

      This is how my data is structured to work from 

       

      ReceivedRegistered1st Stage Approvedsecond stage approved3rd Stage Approved
      01/07/202406/07/202412/07/202427/07/202419/08/2024
      03/04/202408/04/202414/04/2024  
      15/08/2023    
      14/07/202319/07/202325/07/202309/08/202301/09/2023
      08/06/202413/06/202419/06/202404/07/202427/07/2024
      23/05/202328/05/2023   
      12/04/202417/04/202423/04/202408/05/202431/05/2024

       

      This is an example of the output table required

       

      DateYTD TotalNo Received (daily)Total Registered (daily)Total 1st Stage ApprovedTotal second stage approvedTotal 3rd Stage ApprovedTotal O/S
      12/07/202470050677782501
      11/07/202465056687578503
      10/07/2024645545215654581
      09/07/2024640 215215635