0 Replies Latest reply: Jan 4, 2013 3:32 PM by ptooks RSS

    Adding YTD Values and MTD into one Scenario

    ptooks
      Anyone have the correct MDX scenario formula (ASO cube 11.1.2) to add YTD values from an "Actuals" scenario with a MTD value from an "Outlook" scenario into a new Scenario?

      EX)

      Mar YTD Scenario -"Actuals" Plus Mar MTD Scenario -"Committed" to equal Mar New Scenario -"Outlook" value

      My outline for time periods is very basic Yeartotal:
      Q1:
      Jan,Feb,Mar, etc....

      Edited by: ptooks on Jan 4, 2013 7:48 AM

      DISREGARD THIS REQUEST - THANKS