Conditional formatting logic problem

[croberts21]

I have Free PBI Desktop v2.100.1182 (64 bit free version Dec 2021) on Windows 10.

I have a measure called "Pct of Est Cost" which calculates a percent in a matrix. I want to make a conditional formatted background color but I get an error. PBI shows me a red "i" in a red circle. The error is "Please check the logic of this rule." I don't really see a problem. Here's my rule. 

"Pct of Est Cost" is a measure: 

Pct Of Est Cost = DIVIDE(JobCost[Act Cost], JobCost[Est Cost],"")

Pct Of Est Cost is formatted as a percent with one decimal place. The value can be less than 1 or more than 1. So if the value is 2, it actually shows as 200% on the matrix.

Can anyone see the problem here? I do not see the problem.

Thank you!

p.s. Could this be a bug that was fixed in a later version of PBI?

EDIT: I also tried to use a gradient for the background conditional formatting like this: 

The matrix also looks wrong as a value of 39% came out with a yellowish background. But I do not want all values to have a background color, some I want to have a background color of white. That's why I put in a minimum number of 200, then 2000. In both cases I have a Pct Of Est Cost had a value of 39% and a yellow background. I'd like values less than 200% to have a background color of white. 

[amitchandak · Accepted solution]

@croberts21 , I think it should be number, not percent. (percent is for distribution here)

if your column has been marked as percent column, then 200% will be 2 not 200

[croberts21]

Thank you. Your hint helped me fix this, and I tweaked some numbers in the conditional formatting gradient.