Why isn't my Conditional Formatting rule applying to my Percent values in table visuals/table calculations?

Last Tested: Jan 21, 2019

This can happen if you are applying a Default Format option or a value_format OR value_format_name on your Table Calculation or LookML fields, respectively. For example:

Table Calculation Expression

${products.count}/sum(${products.count})

This will typically produce a value on the scale of 0.0 to 1.0, where 0.75 represents 75%. In the UI you can apply a format option from the format dropdown like "Percent( 1 ) -- 123,456.7%" to always show 75%. However any conditional format rules still need to apply to values in the 0.0 to 1.0 range.
 

Measure / LookML Field

measure: percent_calc {

type: number

sql: ${order_amount} / ${sum_all_orders} ;;

value_format_name: percent_1

}

This is a similar scenario as above. The values in the Explore table will show full ##.#% values, but any calculations or conditional formats will need to apply to the raw value range, typically 0.0 to 1.0 when working with percents.