Skip to main content

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

The following should work

({overtime hours} * .5) * {pay rate}

an error may return if either of those fields are empty. 

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. 

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. 


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?

 

Reply


Terms & Conditions