Skip to main content
Question

How to calculate FTE

P
Level 4

I wanted to calculate all documents processed by any user per day.

Can anyone help with formula or explanation how it can be done

​

    .
    Level 4

    Hi Preethi ,

    The Logic Could be:

     

    • Take count of documents processed for a particular period - A
    • Take Count of Distinct related users associated with Documents processed for the same period - B
    • Take the count of Days ( It could be weekdays only or Inclusive of Weekends Too depending upon your actual business Needs) for the same period -C

    Formula is: (A/C) This gives you the number of docs processed per day .. Then Divide the same with B to get the number of documents processed by Any user/day

     

    No of Documents processed by Any user per day = ((A/C)/(B))

     

    Hope this helps..

     

    Please mark my response as best - if this is helpful to you.

     

    Regards

    Ayan

     

     

     

    P
    Level 4
    .14600103626 wrote:

    Hi Preethi ,

    The Logic Could be:

     

    • Take count of documents processed for a particular period - A
    • Take Count of Distinct related users associated with Documents processed for the same period - B
    • Take the count of Days ( It could be weekdays only or Inclusive of Weekends Too depending upon your actual business Needs) for the same period -C

    Formula is: (A/C) This gives you the number of docs processed per day .. Then Divide the same with B to get the number of documents processed by Any user/day

     

    No of Documents processed by Any user per day = ((A/C)/(B))

     

    Hope this helps..

     

    Please mark my response as best - if this is helpful to you.

     

    Regards

    Ayan

     

     

     

    Any example code. If possible?

    Reply


    Community Code of Conduct