Add transform to Named Query to sum values

Hello!

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

Do it in the SQL query.

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

No transform required.

4 Likes

This is 100% the way.

2 Likes

Thank you!