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

公開日: Apr 30, 2025

説明

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

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

Cause

User functions cannot be used in a calculation referring fields from different logical tables.

解決策

Change the Relationship to a Join in the data source.

As in this example, the Orders and People are different logical tables.

Screenshot 2024-05-16 at 1.57.56 PM.png

Because Customer Name is from the Orders table and Person is from People table, the error will occur when creating a calculation.

Screenshot 2024-05-16 at 2.03.26 PM.png

Change the Orders and People from a Relationship to a Join.

Screenshot 2024-05-16 at 2.08.08 PM.png

The calculation will now work correctly without error.

ナレッジ記事番号

001920436

この記事で問題は解決されましたか?

ご意見をお待ちしております。