report logic

[devarasu07]

Hi All,

Need to write below logic in expression, if you have any idea please advise me. thanks

a) if the article exists only in Warehouse then need to exclude from report

b) if the articles exists in both Retail and Warehouse then need to show the article and soh amount to be summed

Regards,

Deva

[trdandamudi · Accepted solution]

May be as below: Hope this helps....

Expression:

=Sum({<[ArticleNo] = p({<[Category] = {'WAREHOUSE'}>}) * p({<[Category] = {'RETAIL'}>}) > + <[ArticleNo]= p({<[Category] = {'RETAIL'}>})>} stock)