SYNTAX for a calc field in a BAQ?

Epicor ERP 10
1

In that I need to limit extracted Lab-detail recs to first rec in table,
I must “MIN” a bunch of fields, but ya can’t “MIN” the Labor-HEADl.LaborCollection field.
(Having the fields in GROUP BY does not provide proper output)

Humn… figured to create a calc-field
LH_Labor_COLL field as a CHAR-3 field
to display “MES” when Labor-Collection is ‘TRUE’ (ie: it was a MES entry per time)

SYNTAX format is KILLING ME - HELP !!!

LH_Labor_COLL is to be a 3 char field, blank when LaborCollection is not checked, but “MES” when LaborCollection is checked (ie: true)

2

You are going to have to explain what you want more clearly. the MIN() function only works with group by, so if you need the min, you have to group by. When you say “does not provide proper output” you have to be more specific.

Also I don’t know how converting the check box to MES is going to help with MIN functions. It can be done easily, but I can’t understand why you want it, and what it has to do with the MIN() function.

1 Like