Set analysis Problem

[munna1317]

hi Qvs ,

I have Fields like this

CumulativeSum	Commission
9531	0.01
18616	0.01
25185	0.01
32887	0.01
40131	0.01
42854	0.01
43184	0.01
50594	0.01
55086	0.01
59897	0.01
67257	0.015
75810	0.015
80916	0.015
87958	0.015
89588	0.015
96575	0.015
99079	0.015
105999	0.02
109690	0.02
116689	0.02
123650	0.02
125250	0.02
134719	0.02
136253	0.02
138263	0.02
146517	0.02
146950	0.02
148466	0.02

the Output Should be :

CumulativeSum	Commission
9531	0.01
18616	0.01
25185	0.01
32887	0.01
40131	0.01
42854	0.01
43184	0.01
50594	0.01
55086	0.01
60000	0.01
7257	0.015
75810	0.015
80916	0.015
87958	0.015
89588	0.015
96575	0.015
100000	0.015
5999	0.02
9690	0.02
16689	0.02
23650	0.02
25250	0.02
34719	0.02
36253	0.02
38263	0.02
46517	0.02
46950	0.02
48466	0.02

Plz help in this

Thxs ,

Harish

[anbu1984]

Can you explain your requirement

[munna1317]

hi anbu ,

thxs for rply , req is :

at end of each commission its needs to

60000

0.01

100000

0.015

and after that it should starts from

7257

0.015

5999

0.02

thxs ,

Harish

[anbu1984]

Still not clear

59897	0.01   //Row is missing in output
67257	0.015  //Split to two rows

99079	0.015  //Row is missing in output
105999	0.02   //Split to two rows

[munna1317]

Already there                                                      Output table

CumulativeSum    Commission                CumulativeSum        Commission

59897                       0.01                                 60000                    0.01                         

67257                       0.015                               7257                  0.015                       

99079                      0.015                                 100000                  0.015                          

105999                    0.02                                     5999                       0.02           

[Anonymous]

it would be faster if you can provide Sum values, not only cumulative sum

[maxgro]

see attachment

[munna1317]

hi massimo ,

thxs for great rply , what you have done is exactly correct , but after 2 lakhs its getting '-' Vaules plz find the attactment, and let me knw if the solutuion

thxs ,

Harish

[munna1317]

hi konstantins kozins,

Please find the attachment

Regards ,

Harish

[munna1317]

hi maxgro,

any solution on above req , plz let me knw if any ,

thxs

harish