December2000
asked on
Running Value in SSRS
Hi Experts,
I’m trying to get a running total from a decimal column in a dataset based on code below. There is one record that has value of “S” but instead of displaying Length of that one field, it shows #Error.
=RUNNINGVALUE(IIF(Fields!C lassTool.V alue = "S",
IIF(Fields!Length.Value > 0,Fields!Length.Value,0),0 ), SUM, "V_WEB_DP_Item")
I have another expression that is the same as above but instead of “S” it is “C3”. There are two records with value “C3” and it displays the total of the 2 lengths.
Any idea why if only 1 record matches criteria I get #Error but if two or more match criteria I get the sum of the values?
I’m trying to get a running total from a decimal column in a dataset based on code below. There is one record that has value of “S” but instead of displaying Length of that one field, it shows #Error.
=RUNNINGVALUE(IIF(Fields!C
IIF(Fields!Length.Value > 0,Fields!Length.Value,0),0
I have another expression that is the same as above but instead of “S” it is “C3”. There are two records with value “C3” and it displays the total of the 2 lengths.
Any idea why if only 1 record matches criteria I get #Error but if two or more match criteria I get the sum of the values?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER