Percentage

[#1]

I'm not sure if there's a way to do this or not.

If you look at the table, what I'd like to display is the % corresponding to the CPT Code, not to the overall total.

IE, for 99213, the percentages I"m looking for are 1,444/(1,444+37,308) for the denied part and 37,308/(1,444+37,308) for the paid portion.

I realize clicking on this would bring me right to the results, but to avoid confusion I need show the percentages as above.

Any idea on how I could do this?

[vgutkovsky · Accepted solution]

You can try something like this:count(field)/count(total <[CPT Code]> field)

Regards,

[#3]

You will want to use the TOTAL modifier to ignore the dimension, allowing you to get the total for Paid and Denied. You want to respect the selection on CPT Code, so you need to TOTAL by that field.

Something like this:

Sum(Amount)/Sum(TOTAL <CPTCode> Amount)

That should work for both Paid and Denied. Replace the CPTCode and Amount with the field names from your dataset.

[#4]

Thanks, exactly what I needed.