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.
check the below image change the calculation as like below
Hope this helps kindly mark this answer as correct/helpful so that it will help others
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...