It would be easier if you used one field for debit/credit (debit plus amount; credit minus amount).
Delete your last field sTotalGlobal and add field (type calculation) called cLineDiff (result is number) with MontantReceites - MontantDepense, selecting your regular fields and not the summary fields. Now create a summary field sRunning (which is Total of cLineDiff and at bottom, checkbox 'running.'
If you used only one field, you wouldn't need that calculation at all because the summary would reference only one field (your amount).
Many thanks for this perfectly simple solution.
As a development, would it be possible to associate the running field to a date field? For the moment, the figures change when the order changes. Similar logic to that of a bank statement.
Many thanks again
"would it be possible to associate the running field to a date field?"
I'm not sure what you mean. Running balance changes based upon whether values change in the amount field(s). Can you explain more what you want?
Sorry for being unclear. As I understand it, the result is running as per the order of the entries. If you change the order of the entries, the results are different even if the sum remains the same. So I was wondering if the running calculation could be based on a manually entered date rather than the presented order?
Sort by that date (within the script) instead of the creation order, right before viewing the report. You will need to Show All Records because amounts are based upon records in the found set.
Well that was embarassing. I was ready for some complex calculation. Many thanks for another perfectly simple solution.