"A field is required here"

[KL_Hutchmfg]

I am trying to create a formula to calculate efficiency. I need to divide production hours by the sum of 3 different hour totals *100 to get a percentage. Here is the formula I am using. TIA

Dim nReturn As Number
If {#ProdHoursByWC} <> 0 Then
nReturn = ({#ProdHoursByWC} / Sum ({#SetupHoursByWC} + {#DirectMachHoursByWC} + {#ReworkHoursByWC}) * 100)
If nReturn > 999 Then
nReturn = 999
ElseIf nReturn < -999 Then
nReturn = -999
End If
Else
nReturn = 0
End If
formula = nReturn

 

[lbass]

Try removing the word "sum" and leave the parens as is. The running totals are already summaries that you are adding together. This will only work properly in the footer section of course.

-LB

 

[KL_Hutchmfg]

Thank you! That was super helpful.