Use aggregate functions in a single table database.

I have a database that is a single table. Is there a way that I can use aggregate functions within a single table? Am I missing something?

- Choices_Software_Dean
- 4 yrs ago
- Reported - view
While viewing the table, click any column header. To save changes across sessions, click wrench on the right, make changes, and click wrench again to save.
- Paul.2
- 4 yrs ago
- Reported - view
Does this let me fill a field with the aggregate sum of a different field? I guess that is really what I'm after.
- Choices_Software_Dean
- 4 yrs ago
- Reported - view
Try a formula field with:

let t := (select Table1);
let s := sum(t.Number1);
s
- Paul.2
- 4 yrs ago
- Reported - view
This works perfectly, thank you!

Content aside