Cumulatieve values in script

kris_vliegen — Thu, 19 Sep 2013 10:03:16 GMT

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?

topic Cumulatieve values in script in QlikView