3 Replies Latest reply on Jan 3, 2017 3:00 PM by Scott Ramos

    How to reproduce calculations for all measures

    Scott Ramos

      In a set of a number of distinct measures, I need to compute scaled values (sometimes called standardization). I am doing this currently, for each individual measure, using this calculation (where Alcohol is the measure and RName is the list of samples in the data set):

       

      ([Alcohol] - { EXCLUDE [RName]:AVG([Alcohol])}) / { EXCLUDE [RName]:STDEV([Alcohol])}

       

      With only a handful of measures, this can easily be done for each one independently. But, if I have hundreds of measures? Is there a way to do this for all of them, at once?