Sum on conditional Values

I have a table with Records for employees and evry record has a record type now i need to have a

sum in the table footer or in a group for all employees of Amount Column when Record type is "E"

and the conditions is if this employee by RecordType "D" the amount column is not 0 else then

shuld be 0 is it posible with SSRS

Thanks

Jhknys

danni123

jhknys,

You can use condition in your SUM statements:

Try

=SUM(IIF(Fields!RecordType = "E", Fields!Amount.value,0)

Ham
software_writer_nyc
Hi,

In the table, add a group in the group expression set to Fields!RecordType.Value

and in the group footer Write this expression:Sum(Fields!Amount.Value), This will sum based on the record type value i.e you will get the 'E' count,'D' count.

Hope this helps.

Thanks
barkest
please provide a sample of data as an example (copy paste an example from excel)
WinFormsUser13232
Thanks all for the reply

but what i am trying to do is get sum amount form records that have RecordType "E" but i want to check if thay have a amount in Record by Record Type D so i can just check the sum with this record is it posible

Thanks

Jhknys
Sum on conditional Values