2 Replies Latest reply on Apr 2, 2013 7:21 PM by 18_4_Ever

    MDSHIFT help


      I have below formula, and understand it partly. If the Year member is 'Actuals13' then 'Tot_Sales' is back 1 member in the 'FiscalYear' dim..... Then it get's fuzzy with the remainder... How exactly would I explain this in layman's terms?

      IF(@ISMBR (Actuals13)) @MDSHIFT (Tot_Sales, -1 , FiscalYear , , 1 , Week , ) ;