Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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))
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))