Using a Running Total as a Parameter
Using a Running Total as a Parameter
(OP)
Hi. My report lists a bunch of applications and each application should have one, or many, decisions. The user wants to be able to list the applications that do NOT have any decisions. What I was thinking of doing, was creating a running total of the decisions (therefore I get the ones that have "0") and then create a parameter where the user can query where those are 0. But I can't seem to get a parameter to run off a running total field? Is this something I "can" do, or is there a better way??
Thanks for the advice!
Thanks for the advice!
RE: Using a Running Total as a Parameter
If the field is null when there is no decision, then you could create a formula like this:
//{@nulldecision}:
If isnull({table.decision}} then 0 else 1
Insert a group on {table.applicationID}. Then you could go to report->selection formulas->GROUP and enter:
Sum({@nulldecision}, {table.applicationID)=0
This would display only those apps with no decision.
-LB
RE: Using a Running Total as a Parameter
RE: Using a Running Total as a Parameter
Then in the record selection I put:
(if {?Decisions} = "No Decision" then {@nulldecision} = 0
else if {?Decisions} = "Has Decision" then {@nulldecision} = 1
else if {?Decisions} = "ALL" then ({@nulldecision}= 0 or {@nulldecision}= 1))
This works.
Thanks so much lbass!!
RE: Using a Running Total as a Parameter
(
{?Decision}=“No Decision” and
Sum({@nulldecision},{table.application})=0
) or
(
{?Decision}=“Has Decision” and
Sum({@nulldecision},{table.application})<>0
) or
{?Decision}=“All”
Apologies for neglecting to add in the parameter earlier. Be sure to replace the quotes in my post with your own, as the quotes from my iPad will throw an error.
-LB