asked on August 21, 2017
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
⋅ August 21, 2017
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.
⋅ August 22, 2017
Hello John,
Thank you for your question. Glad it was solved.
Please let us know if anything else comes up.
Regards,
Dmytro.
