SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE yourtable
(
id int,
name varchar(100),
ydate date,
amt_hkd decimal,
amt_jpy decimal,
amt_usd decimal,
amt_twd decimal,
amt_cny decimal,
)
INSERT INTO yourtable VALUES (1,'Amy','01.04.2022',0,5000,0,0,0);
INSERT INTO yourtable VALUES (2,'Bill','01.03.2022',200,0,0,0,0);
INSERT INTO yourtable VALUES (3,'Caty','02.02.2022',0,0,80,2000,200);
INSERT INTO yourtable VALUES (4,'Bert','01.01.2022',NULL,50,NULL,30,NULL);
4 rows affected

SELECT id, name, ydate, amt_hkd + amt_jpy + amt_twd AS amt_others FROM yourtable;


id
name
ydate
amt_others


1
Amy
2022-01-04
5000

2
Bill
2022-01-03
200

3
Caty
2022-02-02
2000

4
Bert
2022-01-01
null


SELECT * FROM yourtable;


id
name
ydate
amt_hkd
amt_jpy
amt_usd
amt_twd
amt_cny


1
Amy
2022-01-04
0
5000
0
0
0

2
Bill
2022-01-03
200
0
0
0
0

3
Caty
2022-02-02
0
0
80
2000
200

4
Bert
2022-01-01
null
50
null
30
null


SELECT id, name, ydate, 
COALESCE(amt_hkd,0) + COALESCE(amt_jpy,0) + COALESCE(amt_twd,0) AS amt_others 
FROM yourtable;


id
name
ydate
amt_others


1
Amy
2022-01-04
5000

2
Bill
2022-01-03
200

3
Caty
2022-02-02
2000

4
Bert
2022-01-01
80

id	name	ydate	amt_others
1	Amy	2022-01-04	5000
2	Bill	2022-01-03	200
3	Caty	2022-02-02	2000
4	Bert	2022-01-01	null