- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conditional color expression
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),'')
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
pfa,try to repalce the same expression on backgroubd definition & see or work around.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need a multiple condition script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))