Hello!
In perspective how could I add the values of a row and put them in the TOTAL column with a Transform?
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.
This is 100% the way.
Thank you!