Null Values not recognizing as number

[NickBentley]

Hi all,

I have straight table where I want to highlight values greater than 75% in green and less than 75% in red. 

I am achieving this by adding an if statement to the end of the expression within the Background Colour option. 

if((sum({<[Difot Week Start Date]={"29/06/2020"} >}[Difot Units Received]))

/
(sum({<[Difot Week Start Date]={"29/06/2020"} >}[Difot Units Ordered]))<=.75 ,RGB(255,196,196),RGB(185,255,185))

However, in the cases where the expression results in null the null value is returning green and not red as I wish. Even when I convert the null to zero, it is still displaying green.

Appreciate any advice on how to solve this. 

Thanks,

Nick

[tresesco · Accepted solution]

So basically you have to put your red condition in else part of the expression. Tyr like:

If( Expr >75, green, red)

[NickBentley]

Thanks Tresesco! That has worked well.

Cheers,

Nick