1 of 1 people found this helpful
Looking at the formula you are using I imagine that the [Max Actual Sales Date.Other Data Source] is aggregated using the MAX function and you are getting the error because [Forecast Date], [Forecast Sales] are not aggregated. More information about this error can be found here: Resolving "Cannot mix aggregate and non-aggregate arguments" Calculation Error | Tableau Software
One option may be to alter the formula to look something like this: IIF( [Max Actual Sales Date.Other Data Source] = ATTR([Forecast Date]), SUM([Forecast Sales]), 0 )
If this information doesn't help, can you provide a packaged workbook or sample data & workbook?
That worked! Thank you so much!