Sum from other table

[Mattsshop]

I have my app almost working and it is a simple quoting app, I am trying to total my projects from all sub totals in the estimate sheet. It says it is working but the sum value is always 0. Here is my Formula. I am fairly new so I am not sure if this is enough info to evaluate my formula. Thanks for any help.

SUM (Select(Estimates[Sub Total],Project=[_THISROW].[Project]))
Test
open_in_new
Note, this expression could significantly impact sync time.

SUM(
…The list of values of column ‘Sub Total’
…from rows of table ‘Estimates’
…where this condition is true: ((“Project”) is equal to (The value of ‘Project’ from the row referenced by ‘ProjKey’)))

Thanks,
Matt

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

There is a small syntax error in your expression. Could you test the following. The syntax error part is highlighted below.

SUM (Select(Estimates[Sub Total], [Project] =[_THISROW].[Project]))

[Mattsshop]

Thanks for the reply and help Suvrutt_Gurjar, but I still get a 0 outcome on the sum from the referenced rows in the estimate table. When I sum just Estimates[Sub Total] it works fine but that is all the rows and I want to group only rows with the specific Project. All my other formulas seem to work but this one. I am studying now on what exactly a List is.

Thanks,
Matt

[Steve]

Your expression should be in the App formula setting of a virtual column in order that it be updated automatically. Is it a virtual column?

See also:

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Mattsshop · Accepted solution]

Thanks Steve, I know it has been a few days but I forgot to post that I got it working and a Virtual Column is what I needed.