Help with expression

[hopkinsc]

Hi, i am trying to get an expression to show me TotalValue of some Stock Movement Reason Codes but excludding some descriptions...

My fields are:

StockValue

Stock movement Reason Code

Narrative

I want the sum of StockValue for Stock Movement Reason Codes '3,5,16,18' but exclude values with a Narrative of either 'WASTAGE' or 'DAMAGED'

I have the following working for the first part..

sum  ( {<[Stock Movement Reason Code] ={3, 5,16,18}>} StockValue)

but i am unsure on how to add the 2nd part.

Can anyone help please?

Thanks

[CELAMBARASAN]

Hi,

     Check with this,

     sum  ( {<[Stock Movement Reason Code] ={'WASTAGE','DAMAGED'}>} StockValue)

Celambarasan

[hopkinsc]

Hi, thanks but that doesn't work.

I need it to INCLUDE Stock Movement Reason Code 3, 5,16,18 and EXCLUDE Narratives WASTAGE and DAMAGED.

Thanks

[CELAMBARASAN · Accepted solution]

Hi,

     Sorry wrongly understood your problem.

     Here is the solution

     sum  ( {<[Stock Movement Reason Code] ={3, 5,16,18},Narrative-={'WASTAGE','DAMAGED'}>} StockValue)

Hope it helps

Celambarasan

[Anonymous]

Hi There,

Try this (assuming Narrative is also a field):

=Sum( {$ <[Stock Movement Reason Code] = {3,5,16,18} , [Narrative] -= {'WASTAGE','DAMAGED'}>}StockValue)

Is this what you are looking for?

[hopkinsc]

Thats great, thanks very much