Elaine
Top achievements
Rank 1
Rank 1
Is there a limit on the number of RunningValue() functions we can use in the same scope (group) as I have 3 and the first one behaves as expected, the others don't produce the expected result.
I've copy and pasted the working one, to replicate it and the replication doesn't work, so it seems like there is a limit but I can't really understand why there would be.
this works
=RunningValue("group1", sum(Fields.value))
this doesn't work
=RunningValue("group1", sum(Fields.volume))
For reference what I'm using the RunningValue() in expressions for accumulated date in text boxes
Eg
Value, Volume, Accumulated Value, Accumulated Volume
There are no restrictions on how many times the RunningValue data function may be called in the report.
Please note that when a group is specified as the scope, such as in your case, the running value is reset when the group expression changes and the value resets to 0 for each new instance of the specified parent scope.
What may be happening is that new instances of the group - "group1" are created, thus the value resetting to 0 and not adding up, please check whether that is the case and if so - you may need to use a different scope.
If you need further assistance, please send a sample report with data so that I can inspect the issue locally and suggest changes.