Logic Required

[abhaysingh]

Hi Guys Below is the input data, in this on the basis of Test Measure output, there Color coding required. Please suggest

ID	iss	Rss	Test	OUTPUT Required
C162383	2C/1M	2C/1H	C/H/M/L	RED/RED/AMBER/GREEN
C165007	1C/1H	1H	C/H	RED/RED
C165939	1M	1M	M	AMBER
C172291	1L	1L	L	GREEN
C174646	1H/1L	1C	H/L	RED/GREEN

[OmarBenSalem]

I think if conditions should work; sthing like:

if(Test='C',Red(),

if(Test='H',Red(),

if(Test='M',Amber(),

if(Test='L',Green()

))))

[abhaysingh]

thanks , I tried but w.r.t single output it is working but if I have multiple string king output like C/H/M/L its not working

[OmarBenSalem]

And u want to show this in a table object?

[abhaysingh]

yes

[OmarBenSalem]

You can't do that; you can't color a cell in a table with different colors..

[abhaysingh]

ok , is it possible to color values from backend?

[consultant_bi]

except if he create 3 columns to display in each one the color he want , by the master dimensions of the same field Test

and in the content of the column just show nothing like :   if(len(test)<>0,' ') and also title if you want to change it,

and in expression of background color put for the first column you created this :

if(test='C',Red(),

if(test='C/H/L',blue(),

if(test='H/L',Red(),

)))

in the second one :

if(test='C/H/L',Green(),

if(test='H/L',green(),

))

and continue on the same logic