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

I created the following formulas ...

Provider % = COUNT( 'MEDONE_Charge_Dataset'[CPT_Code])
 
Color 2 = IF ( [Provider %] > 1.1 * [Group Average (Ignore Degree)] , "Green" , IF ( [Provider %] < 1.1 * [Group Average (Ignore Degree)] , "Red"))
 
But everything came back "Red", but i dont know why?

 

 

 
 
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

I have a doubt on the Group % measure (the unit)!!

Since Group % is constant and equal 0.0167 can you replace in this formula

Color 2 = IF ( [Provider %] > 1.1 * 0.0167 , "Green" , IF ( [Provider %] < 1.1 * 0.0167 , "Red")) or

Color 2 = IF ( [Provider %] > 0.01837 , "Green" , IF ( [Provider %] < 0.01837 , "Red"))

 

let me know