How can I sum a field in Crystal Reports based on an IF Condition?

See more:

C#

CrystalReports

Hello, friends.

I've three formula fields in crystal reports as follows:
sumAccrued
sumDeducted
sumPaid

and I have a column called "Amount" in the table "Transactions"

if the cell content = 'Accrued' then sumAccrued
if the cell content = 'Deducted' then sumDeducted
if the cell content = 'Paid' then sumPaid

I've done these codes in the formula fields:

if {Table1.Type} = 'Accrued' then SUM({Table1.Amount})
if {Table1.Type} = 'Deducted' then SUM({Table1.Amount})
if {Table1.Type} = 'Paid' then SUM({Table1.Amount})

but it shows 0.00 in the report viewer!!

what is the error?