Expression

[devarasu07]

Hi,

=Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'}>}) * p({<ShopCategory = {'RETAIL'}>}) > + <ArticleNo= p({<ShopCategory = {'RETAIL'}>}) >} soh)

Need to use above logic (ShopCategory filter) into below set analysis expression, do you have any idea to change it?

=Pick(Match(ValueList('A Stocks', 'B Stocks', 'C Stocks'), 'A Stocks', 'B Stocks', 'C Stocks'),

Sum({<ArticleNo = p({StockA}ArticleNo)>}soh),

Sum({<ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>}soh),

Sum({<ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>}soh))

Note: here StockA, StockB and StockC are alternate State

Thanks!

Regards,Dev

[devarasu07 · Accepted solution]

Managed to fix,

=Pick(Match(ValueList('A Stocks', 'B Stocks', 'C Stocks'), 'A Stocks', 'B Stocks', 'C Stocks'),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockA}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockA}ArticleNo)>}) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockA}ArticleNo)>})>} soh),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockB}ArticleNo)>})*e({StockA}ArticleNo) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>})>} soh),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockC}ArticleNo)>})*e({StockB}ArticleNo) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>})>} soh))