Running total for a criteria

[ikzouhetnietweten]

I have a query ' Mut1' and I want it to show in a new field the running total of the field Rent but only for the rows where the event = 'in'. So it should skip counting the values if the event is 'out'. Any idea how I can get it in the query (probably an expression)

In the report I can do a running total, I added it (Property of the report - Data - Running sum over group) but that gives me a running total over the group (the event 'in' AND 'out' but I only want 'in'.)

 

[informer]

Hi ikzouhetnietweten

I don't really understand your request, so could you give me example with expected outcome?

But for example, in you report, for calculating the record number with Event = In, add a text field with this expression:

=Sum(Iif([Event]="In";1;0))

And you will obtain :23