6 Replies Latest reply on Sep 12, 2018 1:36 PM by Ken Flerlage

    Percent Range filter on dashboard

    Santiago Canon

      I am currently trying to create a percent range filter for my dashboard for products not quoted.

       

      I want my filter to be from the following:

       

      0%-9%

      10%-19%

      20%-29%

      30%-39%

      40%-49%

      50%-59%

      60%-69%

      70%-79%

      80%-89%

      90%-100%

       

      I created a calculated field that looks as such:

      IF (given field) > 0 AND (given field) <= .09 then '0%-9%'

      ELSE IF...............

       

      And so on till 100%. It seemed like the code is correct since it stated the calculation was valid but then when I attempted to apply the filter it ran into errors and quite simply would not apply the filter.

       

      Data within the workbook is propriety so I am afraid of releasing it. Any work arounds that I can do by better describing or?