# Add transform to Named Query to sum values

**URL:** <https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [May 24, 2024, 1:13pm UTC](https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866 "2024-05-24T13:13:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [May 24, 2024, 1:13pm UTC](https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866/1 "2024-05-24T13:13:21Z")

</div>

Hello!

In perspective how could I add the values of a row and put them in the TOTAL column with a Transform?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/8/7830b5141b86374f1cb464dc81d8775f5145c3cf.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 24, 2024, 1:15pm UTC](https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866/2 "2024-05-24T13:15:07Z")

</div>

Do it in the SQL query.

```python
SELECT
  RIESGO,
  col1 + col2 + col3 + ... + colN AS Total,
  col1,
  col2,
  col3,
  ...
FROM myTable
WHERE ...
ORDER BY

```

No transform required.

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [May 24, 2024, 1:18pm UTC](https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866/3 "2024-05-24T13:18:41Z")

</div>

This is 100% the way.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [May 24, 2024, 1:34pm UTC](https://forum.inductiveautomation.com/t/add-transform-to-named-query-to-sum-values/90866/4 "2024-05-24T13:34:48Z")

</div>

Thank you!