How to change values to positive and how to change the colour of the value?
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.
