Sum for BAQ

Epicor ERP 10
, , ,
1

I am wanting to sum the OH for certain part bins in a baq, but I do not want to have PartBin out in the display columns. Thoughts on how to do this?

2

End up doing Case when Max(PartNum) = ‘BinNum Wanted’ then sum(ONQTY) else 0 end. The MAX() worked to keep PartBin out of the displayed fields.

3

A sub query is the best way to handle this

1 Like
4

Can you give me an example on how you would do this? Every which way I tried with a subquery, without using MAX(), couldn’t get the desired outcome.

5

Please show what you want your output to be. that would help get you an answer.