Add 2 new columns : Approved and Declined

[#1]

How to add new columns which will have 2 column name as Approved and Declined and in those columns there TransactionAmount respective for each customer, and leave the row blank if in Approved column  the TransactionAmount for that Customer is declined.

Approved columns should only have Transaction Amount which were Approved and Declined Columns should only have TranscationAmount which were Declined

[#2 · Accepted solution]

Create a new column and name it "Approved".  

Add a formula for the column:

If( :Status == "APPROVED", :TransactionAmount, .);

Add a second column and name it "Declined

Add the following formula to it

if( :Status == "DECLINED", :TransactionAmount, .);