0 Replies Latest reply: Nov 27, 2012 10:28 AM by Chirag Chhatralia RSS

    Conditional expression based on dimension value

    Chirag Chhatralia

      Hi,

       

      Is it possible to only have a calculation execute when the dimension is above a given value?  As an example;

      Years =  2010, 2011 and 2012

      Actual Sales for 2010

      Budget Forecast and Actuals for 2011

      Budget and Forecast for 2012

       

      I want to compare 2011 Budget versus Forecast so there wouldn't be a variance calculation for 2010 - so I want to show only Actuals; however for 2011 and 2012 I want to calculate the variance between actual sales and the 2011 Budget.  Is it possible - if my scenario makes sense!?

       

      Thanks

      C