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

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.