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,




      aggregate vs non-aggr function error.jpg