Getting #Error! for Formula

[Ann_Marie_Cain]

I feel like this is an easy solution but I’ve hit a wall.

I’m trying to get a %age. In my formula field I have {Actual Hours Worked}/{Max Capacity}. I have set the format to Percent. Somehow I’m still getting #Error!

Any suggestions what I’m doing incorrect?

[Justin_Barrett]

Welcome to the community, @Ann_Marie_Cain! :grinning_face_with_big_eyes: What types of fields are {Actual Hours Worked} and {Max Capacity}? If either one is a lookup field, that might explain the error, but I’ll refrain from waxing poetic about lookup fields until I see your answer. :slightly_smiling_face:

[Ann_Marie_Cain]

They’re basic input numbers. They’re not being pulled from another location.

[augmented]

Can you take a screen shot of the table, please?

[Ann_Marie_Cain]

Sure thing.

[kuovonne · Accepted solution]

According to your screen shot both fields are single line text fields, not number fields. You need to change the field type to number fields.

[Ann_Marie_Cain]

Thank you for that feedback. I changed the fields from single-line text to number fields. However, I’m still getting the error.

Here is a screenshot of the formula. Maybe I’ve gone wrong there.

[kuovonne]

Can you show a screen shot of the {max capacity} field including the column heading and record values?

[Ann_Marie_Cain]

Thank you so much for your help!! I actually just figured it out.

When I changed the columns from single text to numeric - I missed a column :grimacing: . I appreciate your help on this!!