Help

Disinclude empty values in formula

Topic Labels: Formulas
Solved
Jump to Solution
771 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnieK
4 - Data Explorer
4 - Data Explorer

Hello, I’m trying to calculate an hourly rate using a duration field and a currency field. I have a formula field that calculates $/hr:

({Earnings}*3600)/{Hours Worked}

However, I have a few records where I don’t have the number of hours worked, just the earnings amount. The formula calculates this as “infinity,” which messes with my sum of the entire column. Is there a way to tell this formula to leave the cell blank if there’s no hours worked?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Use this:

IF(
{Hours Worked},
({Earnings}*3600)/{Hours Worked}
)

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

Use this:

IF(
{Hours Worked},
({Earnings}*3600)/{Hours Worked}
)