report logic

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: report logic

trdandamudi — Sun, 20 Nov 2016 00:53:43 GMT

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

Expression:

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