calculate in list

[gatticlaudio]

Hi, how can I do that in the "Balance" column, I have the updated value on each line.
Let it be calculated automatically ....
The list is generated from a mysql view
Thank you.

 

[troester]

Calc elements are calculating on the fly (if you didn't change the default "only calculate on save" from no to yes).
So use a calc element.
Or define your mysql view column as the balance you want to show.

 

[gatticlaudio]

Hi Troester, I thought of a calculated field, but as I refer to the field in the list and it is a partial accumulated, it is not just the difference between 2 columns ...

return ((int) '{Cajaingresoegreso ___ cashed}' - (int) '{Cajaingresoegreso___pagado}');

That calculation did not work.

Thank you.

 

[Nagtegaal]

I go with the suggestion of Troester that you add the saldo in your MYSQL view. The SQL would be something like this:

SELECT fecha, description, sum(sum(pagado-cobrado)) OVER (ORDER BY fecha, description) as saldo
FROM your_table
GROUP BY fecha, description
ORDER BY fecha, description