cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sean Super Contributor
Super Contributor

Re: percent used

Get rid of the column name [PartNumber] - just filter the table - ALL(WorkOrders) in the Total ALL WO Measure

Usates Member
Member

Re: percent used

Thanks for the snipping tool information, I'll start using that.

 

Well, I recently added the WO Master table because I thought that would take care of the issue, which it didn't so I went back to how I originally had it, which is without the "WO Master" table.

 

The WO HDR has distinct doc_no so I have everything back to how you suggested  I create the measures.  My total work orders is off the exact same amount of the work orders that don't appear in the WO_LINE table.

 

We create a work order, which appears in the WO HDR table(Doc_no).  If the work order gets parts assigned to it, it will appear in the "WO_LINE" table.  I have a few work orders that don't take parts, so no entry is found in the WO_LINE table.  
My numbers are off by the amount of work orders that didnt take parts.

Capture.PNG

scottsen Senior Member
Senior Member

Re: percent used

Your model is weirding me out a little bit, wrt to the Part_Number table.  How does that relate to the WO Hdr?

 

I would expect to see a relationship between WO_Line[PartNumber] and 'Part Number'[Part Number].

 

One thing I would say for sure, is that I feel really good about:

  Total WO := COUNTROWS('WO HDR')

 

Getting the count of distinct WO in WP_Line... trickier.

View solution in original post

Usates Member
Member

Re: percent used

Thanks for your help on this!

 

A customer sends us part "A" to work.  When we enter it into our system, it gets assigned a unique number called "Doc_No" and gets one line created in the WO_HDR table.  That line has a column titled "Part Number", which is "A", the part we are working.

 

Now, we tear apart part "A", and find all internal parts that need replaced, lets say three parts need replaced.  We then add those three parts to the work order, which gets recorded in the WO_LINE table.  Each line in the WO_LINE table has a column called "Part Number", which is the part number of the part we issue to it.

 

So, WO_HDR partnumber column is unit being worked, the WO_LINE partnumber is the parts used to complete the unit being worked.

 

In the above example, one line is in WO_HDR table, which has a part number of "A", and three lines appear in the WO_LINE table, which each line has its unique "Part Number", the parts that take to fix part "A".

 

The two tables are linked by the Doc_no

 

Sometimes, no parts are found to be bad, so no parts are issued to it, so nothing gets recorded to the "WO_LINE" table.  Those doc_no are not being counted. 

scottsen Senior Member
Senior Member

Re: percent used

I have had 43 work orders, in which, part number 307083-2 has been used 27 times, equalling a 62.79% usage rate.

 

The 43 work orders, I just expect is what we said before ... countrows(wo hdr).  

When you say "Part number A" is used 27 times, is that JUST the number of times it shows in WO_Lines, or that that also include that it might show in WO Hdr?

 

I still think it is weird that you have a Part Number lookup that is not linked to the part number in your lines table.

Usates Member
Member

Re: percent used

I just linked the part number to the wo_line and I think that with other searching and fixes worked.  I believe I am getting accurate information now.  Thank you for your help on this.  This forum is invaluable and so was your help!

 

Capture.PNG

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,538)