Wednesday, November 19, 2014

substruction in subtotals

Hello,


Your report seems to have only one column group which will have maximum of two distinct values A and B (replace this with appropriate values). If yes, you can use the following expression in the column group total.



Sum(iif(Fields!ColumnGroupField.Value = "A",-1*Fields!Value.Value,Fields!Value.Value))





--sIbu



No comments:

Post a Comment