FM 17 not adding correctly ... or I am insane

Also, whenever you see a database design that has 25 fields in a single table (Field1, Field 2... Field25). you are almost surely using a poor design. You probably should have these 25 fields in a related table

See Database normalization - Wikipedia

When you normalize the database, then your Sum() formula becomes trivial:

MySummationField = Sum(ItemsTable::Price)

4 Likes