4 Replies Latest reply: Jun 21, 2012 5:10 AM by Juan Antonio Bahamontes Rosa RSS

    Is it possible to use a variable as a part of a field name

      Hi. I´m trying to change the name of a field which is in to an expression using a variable as a part of the field name.

      For example something like this:

       

          Having 2 measures:   Quantity, and Sales

           And a group of fields that contains the measure in the field name: Qty_month , S_month

       

      Is possible to do something like this:

       

          Create a variable:  V_measure which will have 2 possible values 'Qty' or 'S' an use it in a expression as follows:

       

                                                                     SUM(V_measure&'_month')  

       

      Thank you