Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))