5 Replies Latest reply on Feb 1, 2019 5:15 AM by Jim Dehner

    Cannot mix agg and non agg

    Alan B

      Hi everyone,

       

      If for instance I want the employee that have sell the most expensive item

      I'll do :

       

           if([sales] = max(sale))

                then [employee]

           end

       

      But I know that I cannot perform this because I'm not able to compare agg and non agg, so how can I do to perform this ?

       

       

      ty in advance