Forum Discussion

jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago

Using Conditional Formatting to show 10% above and 10% below Group%

Using Conditional Formatting how could I highlight the "Provider %" which is 10% above the "Group %"   Using Conditional Formatting how could I highlight the "Provider %" which is 10% below the "Gr...
Need Help
jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago
Color 2 = IF ( [Provider %] > 1.1 * [Group Average (Ignore Degree)] , "Green" , IF ( [Provider %] < 1.1 * [Group Average (Ignore Degree)] , "Red"))
 
Provider % = COUNT( 'Table_Charge_Dataset'[CPT_Code])
 
Group Average (Ignore Degree) = IF (
ISFILTERED (Table_Charge_Dataset[Provider_Degree]), CALCULATE([Group Average], REMOVEFILTERS(Table_Charge_Dataset[Provider_Degree])), [Group Average])
 
 
jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
5 years ago

Your previous comment is 3 formula's correct?  I tried them, but cannot get to work.