12 Replies Latest reply on Apr 2, 2018 12:44 PM by Sarah Zaleski

    count distinct status upon aggregation

    harshitha k

      Hi all,


      I have a calculated field  having the following calculation :

      { FIXED [ID] : SUM([VALUE]) }

      This returns the aggregate of all values of a particular ID. I also have a status(which contains either "A" or "B") corresponding to the ID. My problem is that I am not able to count the status(i.e number of status with value A, number of status with value B). Any help is deeply appreciated.