5 Replies Latest reply on Mar 7, 2017 2:42 PM by Deepak Rai

    Using a Summed Calc in another Calc(mixed aggregate error)

    Mike Janecek

      V10.1

      I need to use a summed calc field in an "if" statement.  The two calc fields I currently have work(see below), but I need the SUM([ALC(seconds)]) in the if statement.

      Currently have:

      but I need SUM([Total Call Duration])/SUM([Total Call Count]) to use in the calc below([ALC(seconds)].

      I can't find a way around the mixed aggregate error.  Any suggestions would be appreciated.

       

      Thanks in advance for any help.