BAQ - Criteria on Calculated Field

Epicor ERP 10
1

Hi All,

Is it possible to put a filter criteria on a calculated field? I have a BAQ which groups records on a table and a calculated field for the sum of the dollar amount of those grouped records.

I don’t want rows with a 0 value from this calculated field to be included on the output. However, sometimes records in the group net out in the calculated field, e.g., SUM(100, -100) = 0, so if I put a criteria on the table those will still come through.

2

SubQuery Criteria

2 Likes
3

Sweet!

image
image707×167 7.11 KB

6 Likes
4

Great answer. Thank you.

5

I am using E9 which has no subqueries. Can this be done in E9?

6

Been a while since E9, so no longer familiar with BAQ Designer. E9 does subQueries different than E10, but should still be possible. My memory fails me on how to accomplish this though. Perhaps someone else still on E9 would have some insight.