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.