# responseFn으로 table 하단에 합계 추가하기

**URL:** <https://ask.selectfromuser.com/t/responsefn-table/66>\
**Category:** 사용 팁\
**Tags:** javascript, responsefn\
**Created:** [8월 28, 2023, 8:23오전 UTC](https://ask.selectfromuser.com/t/responsefn-table/66 "2023-08-28T08:23:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hbkim](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/hbkim/32/23_2.png) [@hbkim](https://ask.selectfromuser.com/u/hbkim)\
**Post date:** [8월 28, 2023, 8:23오전 UTC](https://ask.selectfromuser.com/t/responsefn-table/66/1 "2023-08-28T08:23:10Z")

</div>

조회한 테이블의 일부 항목 합계를 하단에 추가하고 싶으실 때가 있습니다.

responseFn과 Javascript를 사용하면 합산 값을 표현할 수 있습니다.

```yaml
blocks:
- type: query
  resource: mysql.qa
  sqlType: select
  sql: >
    SELECT name, inflow, outflow, safeflow FROM wine_stock LIMIT 3
  responseFn: |
    let sum_inflow = 0
    for (const row of rows) {
      sum_inflow += +row.inflow || 0
    }
    rows.push({
      name: '(합계)',
      inflow: sum_inflow,
    })
```