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]))
Note, this expression could significantly impact sync time.
…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’)))