I am trying to create a formula for the following information
Overtime $
This field is Overtime Hours *.50 * Pay Rate
However, I just get ERROR, and I am stuck
This was the excel formula =SUM(D4*0.5)*B4
D4 being Overtime Hours and B4 being Pay Rate
+17The following should work
({overtime hours} * .5) * {pay rate}
an error may return if either of those fields are empty.
+2Yeah I tried that already, and it is showing error and even if the hours for Overtime are 0 I put a 0 in the field.
+17Yeah I tried that already, and it is showing error and even if the hours for Overtime are 0 I put a 0 in the field.
Hey @BTCM - I just tested it and it works even if fields are empty or zero
Formula:
Is your pay rate field being brought in by a lookup field by chance?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.