634499_en-US

liliconcom

Re: Add 2 new columns : Approved and Declined

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

Add 2 new columns : Approved and Declined

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

Data Exploration and VisualizationPredictive Modeling and Machine Learning