Menu

# Calculated Field Using "percentofcolumn"

Resolved

Hello,
I am trying to use the “percentofcolumn” function in a calculated field.  I can’t get it to return the correct value.  The attached image shows a single provider’s data.  They have a total of 84 patient notes.  18 are “Draft”, 60 are “Final”, and 6 are “Missing”.
The “Pct Missing” column is correct, and it uses the following formula:
sum(“Missing Note”) / count(“Pat ID”)
The “Pct of Col Missing Note” column uses the following formula:
percentofcolumn(“Missing Note”)
The problem is that I think the values for “Pct of Col Missing Note” are incorrect.  I think the “Missing” row should display “100%” in the column, and the “BRACAMONTE,AMANDA C” row should display “7.14%” ( 6 / 84 = .0714), not “43.48%”.  Maybe I don’t understand how the “percentofcolumn” function should work.  Can you tell me how it came up with “43.48%”?
Thank you,
John

### 2 answers

Public

You do not need to respond to my question.  I have figured out what I did wrong.  This is what the “percentofcolumn” function does:

6 / 18722 (grand total of all rows for all Providers)

NOT

6 / 84 (total of all “Missing” for the Provider “BRACAMONTE,AMANDA C”

I didn’t understand how that function works.

Public

Hello John,
Thank you for your question. Glad it was solved.
Please let us know if anything else comes up.
Regards,
Dmytro.