[BUG] expect_multicolumn_sum_to_equal fails if sum_total is another column

Is this a new bug in dbt-expectations?

[x ] I believe this is a new bug in dbt-expectations
[x ] I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

expect_multicolumn_sum_to_equal fails if sum_total is another column

if I have a source table like

      - name: test_counts
        tests:
          - dbt_expectations.expect_multicolumn_sum_to_equal:
              column_list: ["test_pass_count", "test_fail_count", "test_error_count", test_abort_count]
              sum_total: test_count #I can workaround by just doing sum(test_count)

Expected Behavior

I would expect it to not break

Steps To Reproduce

just put a different column in sum_total

Relevant log output

[MISSING_GROUP_BY] The query does not include a GROUP BY clause. Add GROUP BY or turn it into the window functions using OVER clauses.

Environment

- OS: windows 11
- Python: 3.9
- dbt: 1.6.6, dbt-databricks:1.6.6
- dbt-expectations: 0.8.5

Which database adapter are you using with dbt?

Note: dbt-expectations currently does not support database adapters other than the ones listed below.

Postgres
Snowflake
BigQuery

calogica / dbt-expectations

[BUG] expect_multicolumn_sum_to_equal fails if sum_total is another column #290