1 Reply Latest reply on Aug 10, 2016 2:40 PM by diego.medrano

# how to calculate time period for products in different stages???

Hello All,

Am calculating the count of products that enter three stages based on the date

I have Stage1,Stage2 & Stage 3 and Products, i need to calculate count of products by Date(Month) to show how many products are in each stage for a particular month.

Using this i have to calculate "Total" & "Total Completed"

Total - Total number of product is the number of product that is available for a particular month,

Total Completed - It is based on the exit date of a particular product from one stage to another.

Example : if Product A enter stage 1 on 26 November 2014 and be there till 28 November 2014 ,during this time period it falls on total category and when its exit

that stage it must be total completed.

Products           Stage           start date                               End date

Prod A           Stage 1      3/5/2015 4:21:37 AM           3/5/2015 4:21:37 AM

Prod A           Stage 2      5/29/2015 7:40:57 PM         3/5/2015 3:45:25 AM

Prod A           Stage 3      3/6/2015 7:56:32 PM           3/5/2015 3:45:25 AM

Prod B           Stage 1      3/5/2015 4:21:37 AM           3/5/2015 4:21:37 AM

Prod B           Stage 2      9/22/2015 11:50:59 AM       3/5/2015 3:45:25 AM

Prod B           Stage 3      9/22/2015 11:50:36 AM       3/5/2015 3:45:25 AM

Prod C           Stage 1      6/18/2014 10:37:37 AM       6/18/2014 10:57:45 AM

Prod C           Stage 2      2/20/2014 10:40:42 PM       2/21/2014 2:45:22 AM

Prod C           Stage 3      11/17/2014 8:50:21 PM       2/18/2015 12:49:14 AM

Prod D           Stage 1      10/10/2014 2:06:02 PM      10/10/2014 2:09:30 PM

Prod D           Stage 2      10/10/2014 2:09:24 PM      10/10/2014 2:09:30 PM

Prod D           Stage 3      5/22/2015 5:02:02 PM         5/27/2015 8:31:42 PM

Please let me know how to achieve this

PK

• ###### 1. Re: how to calculate time period for products in different stages???

Hey Arnold,

Thanks for posting and asking clearly but successful posts generally have a packaged workbook showing what you've already tried. Could you show us what you've tried so we can add some tips?

Thanks,

-Diego