Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please see attached.
Use FABS() function
Update : Change color accordingly...
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
Thanks Perfect. How to change the colour?
Check enclosed file in previous reply.
On the expression put -
like
= - * today()-aggr(Date(max(DueDate)),CCode)
or use
Fabs(today()-aggr(Date(max(DueDate)),CCode))
Thanks that's good. It's working.
Will this work for you?
And for background color use
by click on + sign in the expression
=IF(today()-aggr(Date(max(DueDate)),CaseCode) < 0,LightRed(),LightGreen())