2 Replies Latest reply: Feb 16, 2017 12:37 PM by Michael Andrews RSS

    Only show Item when average is great than 0

    Michael Andrews

      I have a report where I have Items with a name, and then each item can have responses for it. What I'm wondering is, is there a way I can only show responses where there was at least one selected? I.e. an item may have the responses a, b, c, and d, but only a and b were ever selected. Right now, I'm trying to show them when their average is > than 0, as it would be, if they were ever selected, but it still shows all of the items. What am I missing. I'm trying this


      avg({<ItemScore = {"=Count(ItemScore) > 0"}>}ItemScore)


      But it still shows things that have an average of 0.


      I attached an image of the report to help explain.