IS it possible to use set analysys for Exclude values fiedls ?

[sassoumani]

Hi Every body , 

I need your help please : 

I have a data model with a STOCK and SALES table :`

STOCK : 

ID_ITEM	Stk_Value
10	100
20	200
30	300
40	400

SALES

ID_ITEM	Amount
10	50$
30	100$

I need to return all ITEM in stock with no sale .

what is the simpliest way to do that ? using set analisys ?

[lironbaram]

hi 

no need for set analysis 

you can use this straight forward expression

if(sum(Stk_Value)>0 and sum(Amount)=0,sum(Stk_Value))

[mdmukramali · Accepted solution]

Hi,

You can use the below expression :

=Only({<ID_ITEM= E({<Amount={"*"}>}) >}Stk_Value)

find the attached sample file

Thanks,

Mohammed Mukram