Conditional IIF Sum in SSRS report at group level
Views (11946)
Faisal Fareed
10,796
User Group Leader
Like
Share
ReportI got a requirement where I want to show sum amount based on differnent conditions.
Simple Sum of amount can be shown with following expression;
=Sum(Fields!Amount.Value)
I tried following expression to show conditional sum on a group level; It did not work :(
=Sum(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0))
Simple Sum of amount can be shown with following expression;
=Sum(Fields!Amount.Value)
I tried following expression to show conditional sum on a group level; It did not work :(
=Sum(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0))
I tried following expression after getting idea from this blog and it worked
=Sum(VAL(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0)))
This was originally posted here.
*This post is locked for comments