1 Reply Latest reply: Aug 16, 2012 12:38 AM by Jackson Cardenas RSS

    problem with a sum , problema con una suma

      Good evening I have the following fields with their corresponding values:

       

       

      months    {January, February, March}

      year        {2010, 2011, 2012}

      sales      {100,200,300,400,400,500}

       

      and the following variables

       

      dimension_Name

      dimension_value1 = FieldValue (dimension_name, 1)

      dimension_value2 = FieldValue (dimension_name, 2)

      dimension_value3 = FieldValue (dimension_name, 3)

       

      with two buttons assign the value for the variable "dimension_Name" can be "month" or "year"

       

      you can write the following sum...

       

      = SUM ({<Year={2010}>} [sale])

       

      using variables? something like:

       

      = SUM ({<$(dimension_name)={dimension_value1}>} [sale])

       

      I tried, but so far does not work, anyone know how?

       

      thank you very much

       

      _________________________________

       

       

      Buenas noches tengo los siguientes campos con sus correspondientes valores:

       

      mes  {enero, febrero, marzo}

      año  {2010, 2011, 2012}

      venta {100,200,300,400,400,500}

       

      y las siguientes variables

       

      dimension_name

      dimension_value1 = Fieldvalue(dimension_name,1)

      dimension_value2 = Fieldvalue(dimension_name,2)

      dimension_value3 = Fieldvalue(dimension_name,3)

       

      con dos botones asigno el valor para la variable "dimension_name" que puede ser "mes" o "año"

       

      es posible escribir la siguiente suma:

       

      =SUM({<Year={2010}>}[venta])

       

      haciendo uso de variables? algo como:

       

      =SUM({<$(dimension_name)={dimension_value1}>}[venta])

       

      he intentado, pero hasta el momento no me funciona, alguien sabe como hacerlo?

       

      Muchas gracias

       

      ___________________________________________________________________________________

        • Re: problem with a sum , problema con una suma

          well, I think I found the solution to the problem, the function is:

           

          = SUM ({<$(dimension_Name) = {$(dimension_value1)}>}sales)

           

          but if there is a better answer, I would like to know,

           

          Thanks!

          ___________________________________________________________

           

          bueno, creo que encontre la solucion al problema, la funcion es:

           

          = SUM ({<$(dimension_Name) = {$(dimension_value1)}>}sales)

           

          pero si hay una respuesta mejor, me gustaria conocerla,

           

          gracias.