Conditional color expression

[dmxmikey]

I have below script and would like to add a condition that if output is 'M' I need to color with RGB(291,191,0)

=if(aggr( Concat( DISTINCT if([ALL.alg-code]='SO2',if([ALL.qual-code]='M','M',if([ALL.alg-stat]='N','N',if([ALL.alg-stat]='Y','Y',))),null()),'-'),[p-code],[PRODUCTS.p-desc],[PRODUCTS.p-size],PRODUCTS.origin)='Y',RGB(255,0,0),'')

[buzzy996]

pfa,try to repalce the same expression on backgroubd definition & see or work around.

[dmxmikey]

I need a multiple condition script

[sunny_talwar · Accepted solution]

May be this

Pick(Match(Aggr(Concat(DISTINCT

    If([ALL.alg-code] = 'SO2',

    If([ALL.qual-code] = 'M', 'M',

    If([ALL.alg-stat] = 'N', 'N',

    If([ALL.alg-stat] = 'Y', 'Y',))), null()), '-'),

[p-code], [PRODUCTS.p-desc], [PRODUCTS.p-size], PRODUCTS.origin), 'Y', 'M'), RGB(255,0,0), RGB(291,191,0))