1 Reply Latest reply on Feb 25, 2013 11:23 AM by Tracy Rodgers

    Create calculated field

    Iris Iris

      Dear all can you please help me on this issue. I have for example a Measure which is called “IndicatorValues”  which contains several values, also a Dimension which is called “Indicator” and contains the corresponding names for these values. I want to create a calculated field which reflects the Average of all selected “Indicator”.  For example in the filter if I select only 10 out of 20 of “Indicator”, the calculated value should be only for those 10.

      Thank you

        • 1. Re: Create calculated field
          Tracy Rodgers

          Hi Iris,

           

          You can do this by creating a calculated field similar to the following:

           

          window_avg(sum([IndcatorValues]))

           

          Depending how your view is set up you may need to change for the calculation is being computed. To do this right click on it and select Compute Using..>the appropriate selection.

           

          Hope this helps!

           

          -Tracy