Cumulatieve values in script

[kris_vliegen]

Hi,

In our bookkeeping database we have for our accounts an openingvalue.

On 1 jan 2013 this value is 6585964,68.

On daily base we do bookings.

Now, if I select a year and month (2013 May)in My QV-doc I would see the openingvalue for the mont May.

where Opening = If(sum(Openingsbedrag) = 0 or IsNull( sum(Openingsbedrag)) , below([Closing],1), sum(Openingsbedrag))

and Closing = If(sum(Openingsbedrag) = 0, below([Closing]) + (Sum( { $<J...

Is there a way to save an openingsvalue on daily base?