Percentage formula

Weston Johnson

I am trying to get a percentage of admin from the total hrs logged in the individual utilization collumn using this formula but it is not working. =IFERROR(Admin@row / [Total Hrs Logged in]@row, "") please help.

Weston Johnson

I figured it out so thank you I had some column properties incorrect "Allow Multiple Values per Cell" on which caused the issue.

Nick Korna

Hi @Weston Johnson

What type of column are your Admin/Total Hrs Logged in columns?

It looks like they are dropdowns with multiple options allowed selected - if you remove the multiple options then your formula should work.

Alternatively this can jump to doing the percentage directly without making any changes - assuming your columns are only having one option selected:

=IFERROR(VALUE(LEFT(Admin@row, LEN(Admin@row))) / VALUE(LEFT([Total Hrs Logged In]@row, LEN([Total Hrs Logged In]@row))), " ")

Hope this helps; post if you have any problems/queries though.