Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have the attached script that I would like to highlight results depended on result
Attached is my script
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...
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'.
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.
This works perfect.
Thanks for your help
Delivering the best in Foodservice...