SUM() function fails to dereference values from a related child table, consistently returning 0

AppSheet AppSheet Q&A
, ,
1

1. Table Structure:

  • Parent Table: Sales Order

    • Key: Sale Order Number (Type: UniqueID)

    • Total Column Formula (Failing): SUM([Related Sales Order Details][Subtotal])

    • Related List VC: Related Sales Order Details (Formula: REF_ROWS('Sales Order Details', 'Sale Order Number'))

  • Child Table: Sales Order Details

    • Ref Column: Sale Order Number (Type: Ref to Sales Order)

    • Value Column: Subtotal (Type: Number)

2. Proof of Failure and Diagnostics Performed:

  • Ref Works: The virtual column [Related Sales Order Details] is correctly populated with the list of related row keys.

  • Subtotal Test: I temporarily changed the Subtotal column’s App Formula in the child table to a fixed value of 100. The parent Total column still returns 0.

  • Dereference Failure: I ran a diagnostic test in the parent table using: CONCATENATE([Related Sales Order Details][Subtotal]). This formula returns nothing ("" / blank), confirming that the dereference operation is failing to pull the values from the Subtotal column.

  • Schema Reset Attempts (Failed):

    • Tried Regenerating Structure on the Sales Order Details table.

    • Tried Deleting and Re-adding the Sales Order Details table completely.

3. Request:

Given that the Ref list is correct but the dereference fails across multiple resets, I suspect an internal schema or metadata corruption issue. Could a developer please advise or look into the app’s configuration?

image
image355Ă—427 14.1 KB

1 Like
2

To get a developer involved, you’ll need to go through Support.

1 Like
3

Put the sum function at parents column formula value. Use sum function with select functions.

4

Hi Steve,
Thanks for your response. I’m still new to AppSheet, Can you please let me know how I can access or request the support you mentioned?

5

I already did that, and it still return 0 for sum function

6

Is it solved or ?

7

No

8

Hello @Waristha_Tipwan,

Here are the steps to get in touch with the support team.

To do so, click on this link, scroll down to the bottom of the page and you will find the link to Contact us and go through the following steps:

Step 1: What can we help with?
Step 2: Resources
Step 3: Contact Options

Once you reach the third step, you will be given the option to “Chat” with a team member or “Email” them.

Our support specialists can take a closer look into the issue and help you resolve the problem.

I hope this helps!

1 Like
9

Hi @Waristha_Tipwan

Did you try:

SUM([Related Sales Order Details][Subtotal])

instead ?

2 Likes
10

@Waristha_Tipwan,

You have mentioned your issue in detail. One thing you may want to clarify is if the colum [Total] in the parent table is physical (real) column or virtual column and if it is number or decimal or price or text type.

1 Like