OR in background colour expression

[QlikBeginner1]

Hello.

I have a background expression that I am using :

IF(floor(Max({$<PSystemNamePH={'COGEN'}, TDate -= {''}>}Date))

=

floor(Max({$<PSystemNamePH={'Acturis BE'}, TDate -= {''}>}PDate))

,

RGB(234, 255, 232),RGB(255, 230, 230))

However I need to add an OR condition to this expression where  

floor(Max({$<PSystemNamePH={'Acturis BE'}, TDate -= {''}>}Date)) = NULL

and 

IF(floor(Max({$<PSystemNamePH={'COGEN'}, TDate -= {''}>}Date)) IS NOT NULL

and 

Concat(distinct{$<PSystemNamePH={'COGEN'}, TDate -= {''}>}PDescription,', ') = 'CANCELLED'

AND

Concat(distinct{$<PSystemNamePH={'Acturis BE'}, TDate -= {''}>}PDescription,', ') = 'BLANK'

AND 

If(Round(Sum({$<PSystemNamePH={'Acturis BE'}, TDate -= {''}>}Premium),0.01)
AND
Round(Sum({$<PSystemNamePH={'COGEN'}, TDate -= {''}>}Premium),0.01)

= £0
,
RGB(234, 255, 232),RGB(255, 230, 230))

Whenever I am trying to add an OR into this background expression, an error keeps occuring? Please help with syntax on how to achieve the OR function

[chrismarlow]

Hi,

So I think = NULL needs to be = NULL() and IS NOT NULL needs to be <>NULL().

From there it looks like you have embedded IF statements that don't return anything (so they read like IF(condition) rather than IF(condition,value when true,value when false) & your premium rounding piece you only check if the second condition is =0  (I don't know if the £ causes an issue, but I would probably leave that out).

Cheers,

Chris.