Monday, May 18, 2015

Conditional IIF Sum in SSRS report at group level

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


I tried following expression after getting idea from this blog and it worked
=Sum(VAL(IIF(Fields!name.value = "Standard", Fields!Amount.value, 0)))

4 comments:

I will appreciate your comments !

How to enable new Microsoft teams - Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Micr...