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