3 Replies Latest reply on Oct 9, 2018 12:26 AM by Adolfo Hernandez

    Simple Count Unique Value (with logic)

    Angela.Koh

      hi all, was wondering if this is possible...

       

       

      To only count those [Xy ID] that appears in both 'Chat' and 'Voice' [Media Type]

       

      My attempt failed>

      IF  [Media Type]='Chat' AND  [Media Type]='Voice'

      THEN [Xy Id]

      ELSE 0

      END

       

      Hope u guys can help~