variables creation

[chandra63]

Hi All,

I want to create variables like this.

total_od_recovered_above_90	(Total recovered /total OD) percent is above 90
total_od_recovered_76_90	(Total recovered /total OD) percent is between 76 and 90
total_od_51_75	(Total od/payment tenure) percent is between 51 and 75
total_od_above_90	(Total od/payment tenure) percent is above 90
total_od_recovered_51_75	(Total recovered /total OD) percent is between 51 and 75
total_od_76_90	(Total od/payment tenure) percent is between 76 and 90
total_od_26_50	(Total od/payment tenure) percent is between 26 and 50
total_od_recovered_26_50	(Total recovered /total OD) percent is between 26 and 50
sales_vintage_1	Age of the customer lifecycle is 2
pay_tenure_12	Payment tenure is 12
pay_tenure_24	Payment tenure is 24
total_emi_rlz_26_50	Total (recovered + non od)/payment_tenure percent is between 26 and 50
total_emi_rlz_51_75	Total (recovered + non od)/payment_tenure percent is between 51 and 75

I need help in resolving this.

Please help me here.

Thanks.

[chandra63 · Accepted solution]

Hi Anil,

it  works.

Thanks.its Helpful to me

Chandra

[chandra63]

Hi anil,

please help in this calculations.

avg_gap_bet_od_0	Average gap between two OD instances is 0 months
avg_gap_btw_rec_0	Average gap between two recoveries is 0 month
avg_gap_btw_rec_7_12	Average gap between two recoveries instances is between 7 and 12 months
avg_gap_btw_rec_4_6	Average gap between two recoveries instances is between 4 and 6 months
avg_gap_bet_od_rec_1_3	Average gap between OD and its recovery is between 1 and 3 months

I was wondering if I could get some help please.

Thanks in Advance.

[chandra63]

Hi,

Please help me on the above .

Thanks in Advance.

Chandu