3 Replies Latest reply: Jun 30, 2017 9:55 AM by Tom Neal RSS

    Rewriting a Percentage Expression

    Tom Neal

      Hi All,

       

      Is there an easier way to write this chart expression for converting to percentage?

      I would like to know if the set analysis has to be placed by every sum or is there a way to do an overall set analysis and then calculate the percentage.

       

      sum({<Category = {"Reduce"}>}[<10])/
      (
      sum({<Category = {"Reduce"}>}[<10]) + sum({<Category = {"Reduce"}>}[<100])

      + sum({<Category = {"Reduce"}>}[100-1000]) + sum({<Category = {"Reduce"}>}[>1000]))

       

      Thanks

      Tom