Cross Table Color Expression

[Sony Hejmady]

Hi,

From the Below Table,I need to color Currency Column as Red for Account=111 and Account=222 as it is not macthing with the condition when Account 111 should populate positive values but the Currency column is populating negative values.I have converted Account Code column into Integer.

Same case with Account =222 where expected value should be in negative in Currency but positive value is seen in Currency Column.

Now with the above conditions I need Color Account 111 and 222 in Red under Currency column as they are Errors.

Please help how to color it based on these condititions.

 

 

 

Account

Account Code

currency

 

 

111

+

-1123

 

 

222

-

4578

 

 

333

0

0

 

 

444

+

8900

 

 

555

-

-8651

[Kirsten Smith (she/her)]

I would recommend you vote for this suggestion on our Ideas Portal:

 

https://ideas.tibco.com/ideas/TS-I-5507

[Sony Hejmady]

Yes I voted.So far there is no solution I see.Correct me if I am wrong.I am using 7.11 version.