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?
Best answer by kuovonne
Sure thing.
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.
+21Welcome 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:
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:
They’re basic input numbers. They’re not being pulled from another location.
They’re basic input numbers. They’re not being pulled from another location.
Can you take a screen shot of the table, please?
+29Sure thing.
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.
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.
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.
+29Can you show a screen shot of the {max capacity} field including the column heading and record values?
Can you show a screen shot of the {max capacity} field including the column heading and record values?
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!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
