9 Replies Latest reply: Sep 23, 2014 8:37 AM by A Harish

# Set analysis Problem

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

• ###### Re: Set analysis Problem

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

• ###### Re: Set analysis Problem

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
• ###### Re: Set analysis Problem

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

• ###### Re: Set analysis Problem

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

• ###### Re: Re: Set analysis Problem

Regards ,

Harish

• ###### Re: Set analysis Problem

see attachment

• ###### Re: Re: Set analysis Problem

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

• ###### Re: Set analysis Problem

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

thxs

harish