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