I 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)))
