Forum Discussion
Solved
Divided functions
How can I calculate each FO number / Receiving Qty.?
I received 15,000 but found 4 foreign bodies as the table below. It works only with Bone but others didn't work.
| Receiving Date | Item Code | RM Name | Est. | Supplier name | Killing date | Cutting date | Condition | Lot | Sublot | Receiving Qty. | FO type | FO Num | |
| 11-Jul-22 | 231100152 | RM A | 100 | A | 5/7/2022 | Frozen | 187 | 10 | 15000 | Bone | 23 | ||
| 11-Jul-22 | 231100152 | RM A | 100 | A | 5/7/2022 | Frozen | 187 | 10 | Stone | 1 | |||
| 11-Jul-22 | 231100152 | RM A | 100 | A | 5/7/2022 | Frozen | 187 | 10 | Feed-Corn | 3 | |||
| 11-Jul-22 | 231100152 | RM A | 100 | A | 5/7/2022 | Frozen | 187 | 10 | Plastic | 1 |
Hi Witthawat
Here is a sample file with the solution https://www.dropbox.com/t/qij84hgljVePXolpFO number / Receiving Qty = DIVIDE ( CALCULATE ( SUM ( Data[Receiving Qty] ), ALLEXCEPT ( Data, Data[Item Code], Data[Receiving Date], Data[Supplier name] ) ), Data[FO Num] )
1 Reply
Hi Witthawat
Here is a sample file with the solution https://www.dropbox.com/t/qij84hgljVePXolpFO number / Receiving Qty = DIVIDE ( CALCULATE ( SUM ( Data[Receiving Qty] ), ALLEXCEPT ( Data, Data[Item Code], Data[Receiving Date], Data[Supplier name] ) ), Data[FO Num] )