RunningValue incorrect when Filter in place

Hi there,Found this post in June which describes my problem pretty well, and
I think might be a bug with the way RunningValue interacts with Group
Filters.2 problems:1) There were no replies to the post :)2) My problem is
more complex as I am filtering on an Aggregate on the group below
(=Sum(Price.Value) > 0), so I couldn't just use a conditional RunningValue
function (Aggregrates can't be nested in RunningValue).I am trying to filter
out where the Sum of the subGroup is zero, as another variable is divided by
this amount. With the filter in place, the rows with 0 are not displayed,
but the RunningValue still computers a NaN value because it is including the
zero values!--Currently have a report that displays and entity along with
a sum amount grouped by the entity in a table format.
Name Amount
-- --
Entity 1 Sum Entity 1
Entity 2 Sum Entity 2
I created a min/max parameter to limit the entities by the summed amount.
(i.e. I want all entities who summed amounts are in between $10 and $30) In
addition, there is an overall total based on the summed amounts in the table
footer section. I cannot seem to get the overall total to work correctly.
In all cases, I get the overall total of all records even though I limit the
report with the min/max parameters.
Example report that displays all records:
---
Name Amount
-- --
Entity 1 $20
Entity 2 $10
Entity 3 $5
Overall Total: $35
----
Now I run the report limiting it to summed amounts of $10 and up, and this
is what I get:
---
Name Amount
-- --
Entity 1 $20
Entity 2 $10
Overall Total: $35
---
The parameters work fine in getting the desired report outcome, but my
overall total always shows the overall total of all records. I have tried a
combination of expressions using inscope, runningvalue, sum, etc... and
can't seem to get it to work. Any suggestions?
Thanks...Wow .. that last post formatted itself terribly. Have reposted it.
Hi there,
Found this post in June which describes my problem pretty well, and I think
might be a bug with the way RunningValue interacts with Group Filters.
2 problems:
1) There were no replies to the post :)
2) My problem is more complex as I am filtering on an Aggregate on the group
below (=Sum(Price.Value) > 0), so I couldn't just use a conditional
RunningValue function (since Aggregrates can't be nested in RunningValue).
I am trying to filter out where the Sum of the subGroup is zero, as another
variable is divided by this amount. With the filter in place, the rows with
0 are not displayed, but the RunningValue still computes a NaN value because
it is including the zero values!
Original post below:
--
Currently have a report that displays and entity along with a sum amount
grouped by the entity in a table format.
> Name Amount
> -- --
> Entity 1 Sum Entity 1
> Entity 2 Sum Entity 2
> I created a min/max parameter to limit the entities by the summed amount.
> (i.e. I want all entities who summed amounts are in between $10 and $30)
> In addition, there is an overall total based on the summed amounts in the
> table footer section. I cannot seem to get the overall total to work
> correctly. In all cases, I get the overall total of all records even
> though I limit the report with the min/max parameters.
> Example report that displays all records:
> ---
> Name Amount
> -- --
> Entity 1 $20
> Entity 2 $10
> Entity 3 $5
> Overall Total: $35
> ----
> Now I run the report limiting it to summed amounts of $10 and up, and this
> is what I get:
> ---
> Name Amount
> -- --
> Entity 1 $20
> Entity 2 $10
> Overall Total: $35
> ---
> The parameters work fine in getting the desired report outcome, but my
> overall total always shows the overall total of all records. I have tried
> a combination of expressions using inscope, runningvalue, sum, etc... and
> can't seem to get it to work. Any suggestions?
> Thanks...
>