Little help setting variable in repeat

[JamesJenkins]

@Teodor

 <td class="text-small text-end"> 
                                        <dmx-value id="varBalanceTable" dmx-bind:value="items[$index-1].varBalanceTable.value + (rowtotal-amount)"></dmx-value>
                                        {{varBalanceTable.value}}
                                    </td>

you are truly the master that got it thanks

[Teodor]

Why not do these calculations on the server side and then just send the values to the front end? It will be a lot easier this way.

[JamesJenkins]

just because I dont know how I guess. I tried to do it in the sql and failed as it would involve variables in the sql, not sure how else i could have done it server side.

if there is some guide or previous threads would love a read, as I love trying to learn better ways to do things in wappler

[Teodor]

There's no exact documentation about your exact use case, but you can just use a repeat after your query, loop through the data, do the calculations there with a setvalue step and output it on the front end.