KNOWLEDGE BASE

Error: "Calculations containing user functions cannot reference fields from Physical Tables"


Published: 22 Oct 2020
Last Modified Date: 22 Oct 2020

Issue

Upon creating/editing a calculation field, the following error occurs:

Error: "Calculations containing user functions cannot reference fields from Physical Tables"

User-added image

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.
User-added image

since Customer Name is from Orders table while Person is from People table, the following error occurs.
User-added image

Change Orders and People from Relationship to Join like below: 
User-added image

then the calculation is valid.
User-added image
 

Cause

User functions cannot be used in a calculation referring fields from different logical tables.
 
Did this article resolve the issue?