CODEWITHSUNDEEP
reporting-services
Marc L
Marc L

Reputation: 887

Issue with creating a scoped IIF sum in SSRS Matrix

I am trying to create a column outside of the groups to summarise the totals according to criteria in the sum line. If I use the following expression

=sum(iif(Fields!VATApplicable="NO",Fields!Amount.Value,0))

It gives an error when run

if I try to add a scope to the value amount then it gives that I cannot add a scope there. 

=sum(iif(Fields!VATApplicable="NO",sum(Fields!Amount.Value,"JournalList"),0))

Anyone able to help me structure this to get it to work?

Thanks enter image description here

Upvotes: 0

Views: 125

Answers (1)

AnkUser
AnkUser

Reputation: 5531

How about you create Extra column Let's call it VAT applicable and Set it as Fields!Amount.Value only when Fields!VATApplicable="NO"

This will contain Amount only for Rows where you have VATApplicable="NO".

Now at the bottom you could simply Add Total outside which will give you Grand Total.

Upvotes: 1

Related Questions