2 Replies Latest reply on Aug 10, 2015 6:54 AM by Ian Grossi

    How to count active accounts using a calculated field?

    Ian Grossi

      Hi,

      I want to create a calculated field to count numbers of active accounts based on their investments in a period. I tried in so many ways but I always get a message saying that I can't mix aggregate with non-aggregate comparisons.

       

      I thought that this would work but it didn't... Can somebody give a help?

      SUM(CASE [Account] WHEN [Revenue] > 0 THEN 1 ELSE 0 END)

       

      Thanks!!

       

      Ian