Backround Colour Expression

[GregRyder]

Hi

What is the expression if I want the back round Red for Negative values and green for positive values 

Thanks

Greg

[GregRyder · Accepted solution]

Here is my formula I worked out and it works

if((Sum({<[TXDATE.autoCalendar.YearsAgo]={0}, TCODE={'IN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT)
-
Sum({<[TXDATE.autoCalendar.YearsAgo]={0}, TCODE={'CN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT))
-
(Sum({<[TXDATE.autoCalendar.YearsAgo]={1}, TCODE={'IN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT)
-
Sum({<[TXDATE.autoCalendar.YearsAgo]={1}, TCODE={'CN'}, [TXDATE.autoCalendar.Month] ={"<=$(=Num(Month(Today()))) "} >} AMOUNT)) >0, 'Green', Red())