Hi All,
I am trying to get a formula to work at the foot of a report i have created in report builder using a data set from a stored procedure on SSMS 08.
All it needs to do is sum an amount if a certain word appears in the row, i have tried to use an IIF statement however when i run the report it is summing the whole report instead of jus the selected rows.
This is what i have tried
=(IIF(Fields!Payment_To.Value ="CSL",Sum(Fields!PayAm.Value),0.00))
Any help would be much appreciated
Matt