7 Replies Latest reply: Apr 15, 2014 8:08 AM by S S RSS

    Problem with SUM

    S S

      Hello.

       

      Can you help me to write this expression "sum({$<Scenario={'Control budget '&Year&' (by the quarter)'}>} Sales)", correctly?

      The main term is when I select the Year (for example: 2014), it inserted in the expression and Scenario should get 'Control budget 2014 (by the quarter)' and  expression return total "Control budget 2014 (by the quarter)" sales, when I select "2013" it return total "Control budget 2013 (by the quarter)" sales.

       

      Thanks for your help, Stark