How to get the sum

[paula]

Hello,

How do I get the sum of values inside a virtual column? Thank you!

[dbaum · Accepted solution]

You probably need to explain more.

Meanwhile, a couple points for reference:

• There's a SUM function.
• Whether a column is virtual or not is irrelevant to whether you can sum it.

If you're looking to sum the Total Price column in your screen shot, the expression might be:

SUM([Related Items][Total Price])

[SkrOYC]

Idk what you mean. Virtual columns are considered as any other column so it shouldn't matter.

Are you trying to get a sum of all child records on the parent instead?

[paula]

Thanks! Yes I am

[SkrOYC · Accepted solution]

Build list dereferences - AppSheet Help
SUM() - AppSheet Help

---

SUM(
  [Related whatever][NumericColumn]
)

[paula]

I should mention it's in another table. Does that matter?

[SkrOYC]

From your screenshot is seems is another table but it's a child one.

Please follow through the docs to fully understand how things work:

App design 101 - AppSheet Help

[dbaum · Accepted solution]

You probably need to explain more.

Meanwhile, a couple points for reference:

• There's a SUM function.
• Whether a column is virtual or not is irrelevant to whether you can sum it.

If you're looking to sum the Total Price column in your screen shot, the expression might be:

SUM([Related Items][Total Price])

[paula]

What worked is I made a virtual column to show the result. But I need the result of that to be in the spreadsheet because I need it to show in another app too (they share same data source). How can I make that? Thanks so much!

[SkrOYC]

I'd say it's better to have another VC on the second app because this way it gets updated every sync. If you do this with a real column, you will have to configure a way to update the result everytime there is an add to the child table as well as every change