Color Dimension result

[dmxmikey]

Have the attached script that I would like to highlight results depended on result

Attached is my script

[dmxmikey]

Hi Jonathan,

Thanks for that script, seems to be working and have amended the other data, is it possible to change the script so where there is no data that field is left uncoloured?

Thanks for your help

Delivering the best in Foodservice...

[jpenuliar · Accepted solution]

possibly this:

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

    if(aggr( Concat( DISTINCT if([ALL.alg-code]='PNUT',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),''))

basically, added another IF (expression is 'Y') then change bg color to Green, then at the end you have this part ,'')) which is any other result aside from  'N' and 'Y'.

[jpenuliar]

I dont see any null values on your attached file, i haven't really dig in to your calculated dimension expression, but is there any chance you can have a null result?

Looking at your ALL table, alg-stat is 100% dense.

[dmxmikey]

This works perfect.

Thanks for your help

Delivering the best in Foodservice...