hi Avinash ,
No formula is there the output table must be develop , in QlikView i have one idea ,
but at 200000 its getting minus value , plz find the attactment
Can you please explain the logic that your following...I saw your qvw, peek(cummsum) for few values its taking null values that's why its showing minus values.
If you explain the logic, it will be helpful for us to give the solution.
plz check this :
if(ChangeFlag2=1,left(CumulativeSum,1)+1 & repeat('0', len(CumulativeSum)-1), peek(CumulativeSum2)) as CumulativeSum2
here i am taking the left most character of Cumulative add addng that one ,
but at step of
here it should taking left(CumulativeSum,1) is 1 that is problem iam getting but it should take 14 +1 =15 the output will be correct :
Expected Out put
like this it will come any idea about this logic
the blind logic is for every end of different commission the Cumulative sum must be Round with Below cumulative sum and the it shoould starts form
if(ChangeFlag2=1, CumulativeSum2, CumulativeSum - alt(CumulativeSum2,0)) as Cumulativesum3
like this some logic i got in mind when seeing that excel