0 Replies Latest reply: Sep 17, 2013 6:16 AM by Jeroen Jordaan RSS

    Use variable (which includes a calculation) in set Analysis

    Jeroen Jordaan

      Hello everyone,

       

      I'm trying to create a calculations with Set Analyis but I can not make it work.

       

      I need to identify which items has stock in the past 5 weeks but does not  have any sales.

       

      To calculate the Stock I need to summerize all the stock changes.

      So purchases 10, Sold 5, Purchases 2 is a stock of 7

      I have created a variable called vSellableInventory

       

      Sum({<HFBNo= {$(vSalesHFB)}, CatalogYear=, CatalogYearTertial=, CatalogYearMonth=, CatalogYearWeek=, CatalogWeek=, Tertial=, YearQuarter=, WeeksAgoIndicator= , DateNo= {'<=$(=Max(DateNo))'}>} SellableQty)

       

      No i created a Set Analysis like

      =sum({1<CompanyStoreName = P(CompanyStoreName), ItemNo = {"=$(vSellableInventory) > 0"}, ItemNo = {"=$(vQtySales) = 0"},

      WeeksAgo = {"<= 5"}>} ItemCounter)

       

      This should give me all the items thats has stock but nu sales in the past 5 weeks, but unfortunatily it does not work.

       

      I hope someone can help me.

       

      Thanks in advance