How to add column according to condition?

phoebe_90

After I got column A and B, how can I using tool to get column C-H?

A	B	C	D	E	F	G	H
Amount	Over due days	0 days	1-30days	31-60days	61-90days	91-120days	>120days
1000	0	1000
2000	10		2000
3000	40			3000
4000	70				4000
5000	100					5000
6000	140						6000

ShankerV

Hi @phoebe_90 

Likewise please replicate the above by using + symbol to add.....

Formula tool settings:

Output column: 31-60days

IF [Over due days] >= 31 AND [Over due days] <=60
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Formula tool settings:

Output column: 1-30days

IF [Over due days] >= 1 AND [Over due days] <=30
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Formula tool settings:

Output column: >120days

IF [Over due days] >120
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Many thanks

Shanker V