How do I aggregate up the results from a Calculated field?

Epicor ERP 10
1

The scenario I have is I need to create a BAQ which amongst other things shows Labor Hours and Material booked to a job.

Looking at Labor first, I have joined JobHead to LaborDtl and then created a Calculated field for LaborDtl.LaborHrs*LaborDtl.LaborRate which give me the results for each labor transaction.

What I actually want though, is the total Labor booked to a job so I have been trying to create a Sum calculated field with no success (usually the errors I get relate to grouping).

Would someone please point me in the right direction?

ta.

2

image
image770×206 22.9 KB

image
image409×253 18 KB

3 Likes
3

Thanks, I think I was trying to do it in two steps rather than just one, i.e. I was calculating the cost in one field then trying to sum the results of that separately in another which it wouldn’t allow.