Progress Bar in Template

When editing project the progress bar works fine. When Published and new client opened the progress bar will show >0% even though data does not exist for my limit.
I am referencing a table within my data using: expression binding:

try(sum({DBRprogress.PartsRanTable},"’"+{DBRprogress.PartNumber}+"’"),0)

If search of table fails my value should be 0.

Note: Progress bar is within a Project Template.
Publishing the project will let progress bar work. but if I close and open from gateway I get the error.
Table I’m referencing is polling Relative to project.