I have a report that contains a grouping section. I have a calculated field in the details section with the following expression:
= IIF(Fields.VatTermID=3, Fields.Amount,0), so for every record that has Fields.VatTermID=3 the textbox displays Fields.Amount and for the other records that textbox remains 0. That works fine. However I want to make a total of those fields in the group footer. I tried
= SUM(IIF(Fields.VatTermID=3, Fields.Amount,0)), but it doesn't work. What expression should I use to get the total?