1 Reply Latest reply on Apr 18, 2018 9:31 AM by Ken Flerlage

    Trying to normalize a measure that is already aggregated

    james.evans.10

      I have a measure that has extreme outliers, I determined that any value over 3288 should not be included so I created a calculated field that said " IF AVG([Measure]) < 3288 THEN AVG([Measure]) ELSE NULL END" and converted it to continuous.

       

      Now id like the take those remaining values (those under the 3288 limit) and normalize them to a scale of 0-100 or 0-1. The formula I should use is x - Min(x) / Max(x) - Min(x), but when i try that it says since my measure is already aggregated I cannot aggregate it again.

       

      Does anyone have a solution to this issue?