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.