2 Replies Latest reply on Dec 16, 2013 1:37 AM by Prateek Bhandari

    How do I get around the error 'cannot mix aggregate with non-aggregate' functions for the following screenshot?

    Prateek Bhandari

      Hi all,

       

      I was trying to work out a logical measure but saw the error message as shown below.

       

      I have seen in previous forums that we can't create functions which use aggregate and non-aggregate measures but was wondering if there might be a work around the issue shown below?

       

      Any help would be much appreciated!

       

       

       

      Thanks a ton,

       

      Prateek

       

      aggregate vs non-aggr function error.jpg