CODEWITHSUNDEEP
visual-studioreporting-services
donviti
donviti

Reputation: 294

Runningvalue with a sum(iif

I was successful using Runningvalue here:

=FormatPercent(Runningvalue(Count(Fields!id.Value),Sum,"Tablix1")/ 
Count(Fields!id.Value,"Tablix1"),)

But when I try the next step to only capture the status "A"'s and determine the runningvalue

=Runningvalue(Sum(iif(Fields!status.Value = "A", 1, 0),Sum,"Tablix1")
/ Count(Fields!status.Value, "Tablix1"),)

I'm getting an error: "Has an incorrect number of parameters for the function 'Runningvalue'. I've tried this a number of ways and can't get it to work.

Upvotes: 0

Views: 2786

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

The following expression run without error at least:

=Runningvalue(iif(Fields!status.Value = "A", 1, 0),Sum,"Tablix1")
  / Count(Fields!status.Value, "Tablix1")

There were a few issues with extra commas/parentheses and key words.

Upvotes: 2

Related Questions