5 Replies Latest reply on Jan 29, 2019 9:47 AM by Stephen Groff

# FIXED LOD based on overall total

I've tried a couple of ways of creating this LOD but the totals never work out correctly.  Was hoping some of you pros could take a look.

I apologize, but I am unable to upload this data to this question so we'll work with pictures...

So the pictures above tell me how many defects were found in Assembly, I need to take that number (which is 100) and divide that by the Total Overall Machines found in Work Center 400 (which is 218), not total machines found in Assembly.

I've tried several variations of the following LOD, none of which get me to my total of 218 Machines

Thanks folks

• ###### 1. Re: FIXED LOD based on overall total

Hi, Stephen

It is hard without seeing a sample workbook, but please try below calculation based on my udnerstanding.

{Fixed [Work Center(FG)]:sum(if [Cause Group (CG)] = 'Assembly' then [your defect measure] end)}

/

{Fixed [Work Center(FG)]:countd([Serial No])}

ZZ

1 of 1 people found this helpful
• ###### 2. Re: FIXED LOD based on overall total

Good morning

this is the same as shown below counting sub cats in cat or superstore data

remove the serial number that precedes the colon in your lod

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 3. Re: FIXED LOD based on overall total

Hey Stephen,

I created an example using Superstore.

Your LOD is almost correct, just take out the serial number from the beginning. In my case, { FIXED [Segment]:SUM([Quantity])} -> I called it Fixed

then SUM([Sales])/AVG([Fixed])

Hope it helps.

Best,

Diego

1 of 1 people found this helpful
• ###### 4. Re: FIXED LOD based on overall total

I've tried the solutions... still working out the details.

I've gone ahead and supplied a workbook with what you'll need to see what I see.  Although it may be complicated to navigate..

The number of defects always needs to be divided by the number of machines found in the work center.

I could create a calculation for just assembly results... but I need an all-encompassing calculation.

Total Defects Found in (ie. Assembly or Material handling) / Total Machines Found in Work Center

Jim and Diego... I did as you both stated in your solution, however I've come up with a different number.

1 of 1 people found this helpful
• ###### 5. Re: FIXED LOD based on overall total

This calculation was finally able to give me what I wanted:

essentially what you had originally said:

I never took my date parameter into consideration or how I originally got my machine total.  Once I finally input the [Date Select Param] everything started coming together.

Thank you gents.  Really appreciate you quarterbacking this one for me.

1 of 1 people found this helpful