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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Felix,

 

Thanks for your help, but the line and sum result of HRS_STANDARD is not correct. The calculation details of 'Hour standard' are correct, however the sum is incorrect. See also my remarks in the Power BI file.

 

Can you have a look?

 

Thanks in advance.

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