Conditional Formatting Values shown as percentage of row total

[jdodge220]

Hello,

I have a matrix that counts up values for every day of the week, and displays them as a percentage of the row total. I am trying to apply conditional formatting so that anything under 5% of total, or a blank value shows up as a red background on the cell color. Here are my rules:

however this is how it ends up looking. The blank value field is working, but the % field does not. 

I have tried changing in the conditional formatting to use decimals and whole numbers (.05 number instead of 5%) and it still does not work. The value that it is calculating is a measure with some filters.

Deliveries = CALCULATE(SUM(<table>[ConfirmedDelivery]),FILTER(<table>, <table>[CompleteTrue] = "TRUE"), FILTER(<table>, <table>[ConfirmedDelivery] > 0),

    ALLEXCEPT(<table>, '<table>'[EntityID], <table>[MonthDisplay]))

Thanks in advance!

[amitchandak]

@jdodge220 , In the second column try to use .05 as a number . % means % of the total from min to max %.

[jdodge220]

@amitchandak 

I have tried that. It does not work either. With the below rule, the 2.70% on Sunday should have a background of red, but it does not.