How to change values to positive and how to change the colour of the value?

[#1]

Hi,

I have straight table with

dimensions  as CaseCode,DueDate

expression as Days in List = today()-aggr(Date(max(DueDate)),CCode)

Based on above expression the Days in List is showing negative and positive values. How can I change all values to positive. I need to change the colour of values if the Due Date is future I need green. If Due Date is earlier date(I,e past date) I need red colour. Is it possible? please can anyone suggest me please.

Thanks.

[#2]

Please see attached.

[MK_QSL · Accepted solution]

Use FABS() function

Update : Change color accordingly...

[Greg_Williams]

Have you tried > Chart properties > Expressions > expand expression to show Background image > insert your logic in an if statement (if, logic,rgb(255,0,0),rgb(0,255,0))

rgb(255,0,0) = red, 0,255,0 = green

Hope this helps.

Greg

[#5]

Thanks Perfect. How to change the colour?

[MK_QSL]

Check enclosed file in previous reply.

[its_anandrjs]

On the expression put -

like

= - * today()-aggr(Date(max(DueDate)),CCode)

or use

Fabs(today()-aggr(Date(max(DueDate)),CCode))

[#8]

Thanks that's good. It's working.

[mphekin12]

Will this work for you?

[its_anandrjs]

And for background color use

by click on + sign in the expression

=IF(today()-aggr(Date(max(DueDate)),CaseCode) < 0,LightRed(),LightGreen())