Aug 24, 2023 08:26 AM
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
Aug 24, 2023 09:09 AM
The following should work
({overtime hours} * .5) * {pay rate}
an error may return if either of those fields are empty.
Aug 24, 2023 09:38 AM
Yeah 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.
Aug 24, 2023 09:56 AM
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?
