1 Reply Latest reply on Aug 21, 2016 5:15 AM by Yuriy Fal

    Calculated Field If Then Using Running Sum, Needing to Sum at Weekly Store Level

    Shara Fisher



      I have attached a packaged workbook with the worksheet setup to get the answer I am looking for.


      I am trying to use the formula in "No Movement Store Count L4W along Store" at the store level, but sum at weekly level.  If I move the "Store" out of marks, the measure calculation says it needs a field.  I know we cannot use LOD and table calculations, so I am trying to get around that.


      My goal is to calculation "No Movement Stores" by assigning a 1 to a store for the week/item when: Order On = 1, Inventory >1, Sum L4W>0. Then, I want to count those stores for the week/item.


      Thanks for any help!