BAQ Calculation in E10

Epicor ERP 10
1

I am struggling with the conversion of the following calculation for one of our E9 BAQ’s.
I know I have to Case when … but it’s the else part of it that is causing me grief.

if JobOper.SetupComplete = True then 0 else ((100 - JobOper.SetupPctComplete) * (JobOper.EstSetHours / 100))

2

Oops forgot to finish before I submitted. One of those days… anyway, if anyone can lend a hand with this I would greatly appreciate it.
Thanks in advance!
Carol

3

(case when JobOper.SetupComplete = True then 0 else ((100 - JobOper.SetupPctComplete) * (JobOper.EstSetHours / 100)) end)

4

This is what I have:

(case when JobOper.SetupComplete = 1 then 0 else ((100 - JobOper.SetupPctComplete) * (JobOper.EstSetHours / 100)) end)

but I get the following error:

Column ‘Erp.JobOper.SetupComplete’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

I do have the Group by checked for JobOper.SetupPctComplete

5

well then you will need to sum the statement

sum(case when JobOper.SetupComplete = 1 then 0 else ((100 - JobOper.SetupPctComplete) * (JobOper.EstSetHours / 100)) end)

or remove the group by checks

6

Perfect … that worked. I had tried the sum, but I was putting it in front of the
sum((100 - JobOper.SetupPctComplete) * (JobOper.EstSetHours / 100))
end)

Thank you so much!