I’m just not sure how to translate this into an expression for epicor or where I should be placing this logic.
I’m creating a BAQ to return a table of all jobs that follow certain criteria. I have the table returning correctly, however, we have a column that we use to track how many days away from being scheduled for production that any given job number is.
This is a BAQ and dashboard that is basically replacing an old excel spreadsheet. The Column 0 is originally in excel as the SUM of all Column 1 where Column 2 is scheduled and column 4 is smaller than current rows Column 3.
Pseudocode: if (current.col == NotSched) then current.col = sum(allrows.col1 where allrows.col3 < current.col3)
It is using some UD fields attached to JobOper.