Hello,
How do I get the sum of values inside a virtual column? Thank you!
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?
1 Like
Thanks! Yes I am
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])
2 Likes
3 Likes
I should mention it’s in another table. Does that matter?
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
1 Like
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!
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
3 Likes