Forum Discussion

habaholic's avatar
habaholic
Frequent Visitor
8 years ago

Comparing values from different tables

This question is in regards to a manufacturing environment.   I have cycle time production data from this year (2017) and I want to compare my current cycle times per product to the best cycle time...
Need Help
Tutorial Requests
habaholic's avatar
habaholic
Frequent Visitor
8 years ago

Both tables have dates. However what I am interested in is comparing this weeks production cycle time vs the best time for that product in 2015.

 

Example (this data is in 2 different tables. One for 2015 data, one for 2017 data)

Date                                 Product Code                                  Cycle Time       

01/01/2015                      P123456                                          14

25/08/2015                      P123456                                          10

16/11/2015                      P123456                                          12

04/02/2017                      P123456                                          8      

 

Now I want to compare my 04/02/2017 time to my best time in 2015 (10). So the efficiency would be (8/10)*100=80%.

 

I want to do this for all machines/products for the month and then give me a total d3epartment efficiency based on all machine/product results. I have 45 machines working 24 day, producing many different products per month.                  

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi habaholic,

 

So you want:

*Selected value* / MIN(2015[Cycle Time]) 

(the * 100 is not needed if you set the format to %)

 

of a certain product ?

 

Regards,

L.Meijdam