how to sum after iff condition in ssrs?

Question

I want to sum all the values of the column, using if condition same as the column expression:-

The Expression of the normal column:-

iif(Fields!mcount.Value <> 0 And Fields!TaxCode.Value = 1 ,Fields!InputAmnt.Value,0)

The Expression to sum, I used 2 codes and the same result "#Error" appeared in both cases

sum(iif(Fields!mcount.Value <> 0 And Fields!TaxCode.Value = 1 ,Fields!InputAmnt.Value,0))

and

 iif(Fields!mcount.Value <> 0 And Fields!TaxCode.Value = 1 ,sum(Fields!InputAmnt.Value),0)

any help ?

Can you provide a screenshot or details of how the report body looks? Where are the expressions? — BishNaboB, Sep 21 '16 at 09:19
I wonder if you have to specify the name of a group or dataset that you're trying to sum? Like `sum(iif(....), "")` — Kidiskidvogingogin, Sep 21 '16 at 12:39

score 1 · Accepted Answer · answered Sep 21 '16 at 07:47

1

Try adding VAL from the InputAmnt field. See below expression.

=SUM(iif(Fields!mcount.Value <> 0 And Fields!TaxCode.Value = 1 ,VAL(Fields!InputAmnt.Value),0))

answered Sep 21 '16 at 07:47

Aldrin

1 Answers1