Hi Friends ,

i just added my code with rollup

select

fs_locn,

fs_accno,

fs_cost_center,

amount=sum(case when fs_accno like 'E%' and fs_tran_type='Dr' then fs_amount

when fs_accno like 'E%' and fs_tran_type='Cr' then fs_amount * -1

end

)

from

accutn_det where fs_trans_date between '01-may-2014' and '31-may-2014'

groupby fs_locn,fs_accno,fs_cost_center with rollup

its giving the sum total value with NULL

how to avoid "Null" replace on TOTAL In That???