text color expression

[everest226]

I have following expression. not sure why it has error , result to have red if negative 

Sum({< IsPro={'N'} >} [ Sold] ) / Sum({< IsPro={'Y'} >} [Sold] ) - 1 <0,RGB(255,0,0),RGB(0,0,0))

[sunny_talwar · Accepted solution]

Did you forget to add the if( at the beginning 🙂

If(Sum({< IsPro={'N'} >} [ Sold] ) / Sum({< IsPro={'Y'} >} [Sold] ) - 1 <0,RGB(255,0,0),RGB(0,0,0))