Percentage formula

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.

Answers

  • 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
    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.