SELECT expression omitting values in a list

[Elijah_Magrane]

Good Day,

I am racking my brain to try and figure out why my SUM(Select expression is not returning the correct value.

Here are the values the expression returns in AppSheet…

But as you can see when we look at the DB there are several values that are omitted, and it stops assessing as the 13th row

It is not a duplicate issue within the SELECT statement as it does return some duplicates (I also toggled the Expression from TRUE to FALSE just to see).

Any ideas would be appreciated