Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've got a table with data from my ERP that looks like this:
Item, Price, Status
Status can be: Active, Obsolete, ObsoleteBOM
An item can be active or obsolete. But it can also be Obs AND ObsBOM
I'm trying to color my items by checking the "Status" value. If there is only one status, it works fine (red items when status is Obsolete, ...) but as soon as an item has 2 values (Obs, ObsBOM), the color do not change
Here's the expression I'm using
=if(ITEM_STATUS ='BOMOBS' or ITEM_STATUS = 'OBS', rgb(255,0,0), black())
How can I still have my item turn red if both status are used
I'm pretty sure there is a simple solution but can't find it...
Thank you for your help
I?ve solved my issue using another solution, I replaced one value (ObsoleteBOM by Obsolete) at LOAD
Sadly, it does not work. Items with both status still are in black
Fabien, just out of curiosity, what happens if you change the 'or' to an 'and'? My hunch would be this is something data model related if that works, so you may need to attach QVW or sample etc. such that folks can have a look at that too. Best idea I have to try to move things forward for you.
Regards,
Brett
I?ve solved my issue using another solution, I replaced one value (ObsoleteBOM by Obsolete) at LOAD