I wroted a question that was solved and i'm very grateful for this. (Using the previous result line to calcute the next)
Now, I still in problem with a new calculating.
I have to calculate a result using the previous result.
HAVE:
segment |
month |
safra |
qt_account_initial |
attrition_a |
attrition_b |
perc_affluent |
varejo |
30/06/2019 |
1 |
100 |
2,00% |
2,00% |
10,00% |
varejo |
31/07/2019 |
2 |
100 |
2,00% |
2,00% |
10,00% |
varejo |
31/08/2019 |
3 |
100 |
2,00% |
2,00% |
10,00% |
affluent |
30/06/2019 |
1 |
80 |
2,00% |
2,00% |
0,00% |
affluent |
31/07/2019 |
2 |
80 |
2,00% |
2,00% |
0,00% |
affluent |
31/08/2019 |
3 |
80 |
2,00% |
2,00% |
0,00% |
WANT:
segment |
month |
safra |
qt_account_initial |
attrition_a |
attrition_b |
perc_affluent |
new_acc_initial |
acc_whitout_attrition_a |
acc_whitout_attrition_b |
acc_whitout_affluent |
qt_add_affluent |
varejo |
30/06/2019 |
1 |
100 |
2,00% |
2,00% |
10,00% |
100,00 |
98,00 |
96,04 |
86,44 |
9,60 |
varejo |
31/07/2019 |
2 |
100 |
2,00% |
2,00% |
10,00% |
86,44 |
84,71 |
83,01 |
74,71 |
8,30 |
varejo |
31/08/2019 |
3 |
100 |
2,00% |
2,00% |
10,00% |
74,71 |
73,22 |
71,75 |
64,58 |
7,18 |
affluent |
30/06/2019 |
1 |
80 |
2,00% |
2,00% |
0,00% |
89,60 |
87,81 |
86,06 |
86,06 |
0,00 |
affluent |
31/07/2019 |
2 |
80 |
2,00% |
2,00% |
0,00% |
94,36 |
92,47 |
90,62 |
90,62 |
0,00 |
affluent |
31/08/2019 |
3 |
80 |
2,00% |
2,00% |
0,00% |
97,80 |
95,84 |
93,92 |
93,92 |
0,00 |
TO CALCULATE THE NEW COLUMNS:
new_acc_initial
acc_whitout_attrition_a
acc_whitout_attrition_b
acc_whitout_affluent
qt_add_affluent
Condition for the first iteration : IF SAFRA EQ 1 THEN new_acc_initial = qt_account_initial;
NOTE: The trick is to add the qt_add_affluent result when its filled into the affluent segment line