7 Replies Latest reply: Jul 4, 2016 2:01 PM by Manish Kachhia RSS

    Comparing average with the field

    Ankit Tr

      I have following data sample:

      ID    Category    Value      Flag

        x         A                12      Chosen

        x         B                10      Cancelled

        x         C                 5      Converted



      I need to compare average value (on id level) with that of value of category with 'Chosen' Flag

      The output I need is this:


      ID       Category         Value   Average Value

      x             A                  12         9 (Average of 12,10 and 5)


      I tried applying filter (Flag=Chosen), and ruled it out while calculating average. But, that does not seem to work:



      This would ignore Category and Flag while calculating the average.