I have the following expression within report studio which works fine.
total([ColA] for [TEAM] )
However, i now need to expand that expression to total values only where ColB is equal to the value 1.
I tried using:
total([ColA] for [TEAM] , [ColB]=1)
Unfortunately this does not work. What do i need to change the expression to, so that it achieves this?
any ideas?
CASE WHEN
([ColB]=1)
THEN
(total([ColA] for [TEAM] ))
ELSE
(0)
END