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!ClassTool.Value = "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?