1 Reply Latest reply on Jul 31, 2018 2:25 AM by Naveen B

    help needed with aggregate and non-aggregate calculations

    Yejella Harshita naga venkatasai

      hi all,


      I have the following calculation :


      IF [MAX ORDER DATE]=[Order Date]

      THEN SUM([Base Salary]*[Commission Rate])

      /SUM([Commission Rate])/1.1 END


      This isnt working as tableau is showing an error : Cannot mix aggregate and non-aggregate functions .


      Can anyone please help and get this sorted. I have attached sample dataset and calculation below.


      Thank you.