Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Aggregation not correct

Hi,   For every workorder (MFG_ORDER_NAME), I want to calculate the standard HOURS per operation seq and resource seq. The line calculation is oke, however the sum of HRS_STANDARD is not ok. How ca...
Need Help
MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous,

 

Not really sure if I understand your needs.

 

When you have a LOT you should only consider one line if it's items you should consider all the lines for the SUMX?

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Felix,

 

That is true. When 'Basis' is Lot then I need only need one value/line per OP_seq & RES_seq. If 'Basis' is Item then I need the req_amount * qty completed per OP_seq & RES_seq (which is one line). Finally I need the sum of these elements which will be the req_amount for the complete workorder.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Felix,

     

    Can you have a look at my last reply? Honestly I need the solution urgently.

     

    Regards.