topic Re: Add 2 new columns : Approved and Declined in Discussions

Add 2 new columns : Approved and Declined

NullMongoose240 — Tue, 23 May 2023 18:46:40 GMT

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

Re: Add 2 new columns : Approved and Declined

txnelson — Tue, 23 May 2023 18:21:11 GMT

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, .);