Issue
Upon creating/editing a calculation field, the following error occurs:
Error: "Calculations containing user functions cannot reference fields from Physical Tables"
Last modified date: 10 Jul 2023
Environment
- Tableau Desktop 2020.2.0 and later
Resolution
Change Relationship to Join in the data source.For example, the Orders and People are different logical tables below.
since Customer Name is from Orders table while Person is from People table, the following error occurs.
Change Orders and People from Relationship to Join like below:
then the calculation is valid.
Cause
User functions cannot be used in a calculation referring fields from different logical tables.Thank you for providing your feedback on the effectiveness of the article.
Open new case
Continue searching
Knowledge Base
Community
Product help
Training and tutorials