My date filter formula keeps coming back with the same 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`
Set defined with formula gives 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)
An Introduction to Tableau Calculated Fields and Its Function - BPI - The destination for everything process related
![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
![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/1565890071282-0THYWVC3NCPI5V5IXUAS/99-3.png)