Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm looking to add multiple 'if not' statements to a Valuelist. I currently have a valuelist that looks for orders in a particular status, but would like one to look for orders that do not have a status of 'F' or 'S'... The code I have for the single status is as follows...
=if( vShowQty = 1,
If(Valuelist('PriorYear', 'Budget', 'CurrentYear')='CurrentYear',
sum({$ <[Sales.Year]={'2014/15'}, [OrderStatus]={'F'}>} OSQTY),0)
,
If(Valuelist('PriorYear', 'Budget', 'CurrentYear')='CurrentYear',
sum({$ <[Sales.Year]={'2014/15'}, [OrderStatus]={'F'}>} OSValueGBP),0)
)
Thank you in advance
Andrew
use -
example
=sum({$<City=-{Paris,London,Tokyo}>} id)
[OrderStatus]=-{F,S}
use -
example
=sum({$<City=-{Paris,London,Tokyo}>} id)
[OrderStatus]=-{F,S}
Hi Massimo,
Thanks for your answer!
I did already try this method, but I couldn't get it to work.... There is an error in the syntax apparently. It works in this method like this...
[OrderStatus]={'F','S'}
But not with the 'not equals' in....
Thanks
Hi
I assume you're talking about the red squiggle underline. This is a bug in the expression editor for implicit set operations.
[OrderStatus]-={'F','S'}
is legal, despite the error indication.
If you prefer to not have the error warning, you can write the equivalent logic written with an explicit set operation:
[OrderStatus]={'*'} - {'F','S'}
HTH
Jonathan
You might see red lines appeared in your expression after you added minus. Are you saying syntax error because of red lines or you got "Error in expression"?