just to confirm:

1) Statement Month is a simple choice field or a dynamic choice field.

2) What is the table name of the screenshot? What is the table name that you want to get the totals from?

3) What is the field name in the table that has the month data? What kind of field is it?

If you can, upload a sample of your DB with sample data.

danlap333 said:
1) Statement Month is a simple choice field that I choose
2) Table name is "Receipt Details" 2) Table name that I want to get the totals from is "Receipt Details", but from the "Total" seen in the screenshot
3) Field name is "Statement Month" 3) Field is a Choice Field
Not sure if that matters, but the Total is already calculated from a simple formula not shown:  ('Sub-Total' + HST)

Ok so you can try something like:

let t := this;
sum((select 'Receipt Details' where text('Statement Month') = text(t.'Statement Month')).Total)

If you 'Statement Month' choices have the same choice number then you can remove the text() part.