![Tableau - “Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions.” — OneNumber Tableau - “Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions.” — OneNumber](https://images.squarespace-cdn.com/content/v1/57bfa51129687fe4f8df9bbe/1517337850644-UX5DKWT0DS1URQU37E23/31-2.png?format=1000w)
Tableau - “Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions.” — OneNumber
![Tableau Error: All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources — OneNumber Tableau Error: All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources — OneNumber](https://images.squarespace-cdn.com/content/v1/57bfa51129687fe4f8df9bbe/1565889936868-YWML2ZTS8VB4W2IHRWFB/99-1.png)
Tableau Error: All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources — OneNumber
Set defined with formula gives error `The formula must be an aggregate calculation or refer only to this field`
Set defined with formula gives error `The formula must be an aggregate calculation or refer only to this field`
My date filter formula keeps coming back with the same error "The formula must be an aggregate calculation or refer only to this field."
![20 Uses for Tableau Level of Detail Calculations (LODs) - The Flerlage Twins: Analytics, Data Visualization, and Tableau 20 Uses for Tableau Level of Detail Calculations (LODs) - The Flerlage Twins: Analytics, Data Visualization, and Tableau](https://1.bp.blogspot.com/-SaLmRhxV7Ls/Xj9qxCiaZRI/AAAAAAAAPpg/29FWphqFjo4oGz_CfcIHLkQmPO3tWNoPQCEwYBhgL/s1600/Header.png)
20 Uses for Tableau Level of Detail Calculations (LODs) - The Flerlage Twins: Analytics, Data Visualization, and Tableau
Using a Parameter as a variable for a filter error... "The formula must be an aggregate calculation or refer only to this field"
My date filter formula keeps coming back with the same error "The formula must be an aggregate calculation or refer only to this field."
![An Introduction to Tableau Calculated Fields and Its Function - BPI - The destination for everything process related An Introduction to Tableau Calculated Fields and Its Function - BPI - The destination for everything process related](https://intellipaat.com/blog/wp-content/uploads/2021/09/image-73.png)