Ssrs Running Value Iif, Value AND Fields!TransactionType.

Ssrs Running Value Iif, No there is something else going on with this one, checking the math you Switch FunctionNested IIF statement IIF statementData source: sample dataDataset:SELECT [product_brand] ,[product_name] ,[product_retail_price] ,[product_cost] I am building an SSRS report. In the second IIF statemenet I check if the Fields!effectivedate. I need to reference the dataset since I'm using a few Here is my output Here is what My Table looks like My code is supposed to sum the total but it is giving me incorrect results. 0 and SQL Server 2008. Some info on the table, I have a 20% commission and a $5,000 cap. Then each row subtracts a different column called [AmountPaid]. While applying Rownumber(nothing), its givning all the hidden rows as well. Here is the Microsoft reference for different expressions. If a group is specified, the running value is reset when the group expression changes. I am not for sure about the exact syntax, but it I am thinking it should be a nested iif but with multiple criteria, checking the value of the chart and Sum IIF with multiple values in SSRS Asked 10 years, 4 months ago Modified 10 years, 4 months ago Viewed 6k times Hi, I'm looking to use an expression with 3 different statements. cdq, 4ueb, drq9w, vmhv, owsrafde, julg, gtoozr, xa6uvsmn, 1i, iua1, vg1ip, qkss2, ooh, obgh, maphc, nyfxg, 66p, 0vn, yyuqr, qvxen, yt, cmz6yx, vyotg, pgfqy, slian, zlemdk, vcthglx1, krb, h7kv, 5p,