BASE DE CONNAISSANCES

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


Date de publication : 22 Oct 2020
Date de dernière modification : 10 Jul 2023

Problème

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

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


User-added image

Environnement

  • Tableau Desktop 2020.2.0 and later

Résolution

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.
 
Cet article vous a-t-il permis de résoudre le problème ?