Calculation based 2 condition

[learnflower]

Hi ,

I am facing problem to do a sum of particular column based on 2 condition
eg:

Sum( [Booked Premiums transactions]  for [Business]='Direct' and [Business_segment]='Hull Blue Water')

I need to know how can i calculate  based on the 2 conditions [Business]='Direct' and [Business_segment]='Hull Blue .

By using the above eg i am getting error , please guide me how to proceed on this.

[blom0344]

total(
case
when
([Business]='Direct' and [Business_segment]='Hull Blue Water')
then
[Booked Premiums transactions]
else (0)
end)

[learnflower]

Thanks Blom its working :)