Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Calculated Field Using "percentofcolumn"

John W asked on August 21, 2017

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,


2 answers

John W 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)
     6 / 84 (total of all “Missing” for the Provider “BRACAMONTE,AMANDA C”
I didn’t understand how that function works.

Dmytro Zvazhii Flexmonster August 22, 2017

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

Please login or Register to Submit Answer