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

    MDSHIFT help

    18_4_Ever
      Hi,

      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 , ) ;