Logic

[aveeeeeee7en]

Hi All

Need Logic from Script:

MOB          Desired Output by using MOB

10               10

20               10+20=30

30               10+20+30=60

40               10+20+30+40=100

50               10+20+30+40+50=150

Regards

Aviral

[rustyfishbones]

Can you try in the script

Previous(MOB)/2 AS [New Field Requirement]

looks like this in my example

[its_anandrjs]

Use Previous function.

[aveeeeeee7en]

Hi Alan, I actually want this:

MOB          Desired Output by using MOB

10               10

20               10+20=30

30               10+20+30=60

40               10+20+30+40=100

50               10+20+30+40+50=150

[rustyfishbones]

Yes I see, I am trying to figure it out

[its_anandrjs]

Provide your previous image also where you explain it will more clear.

[rustyfishbones]

Use this expression

RangeSum(above(sum(MOB),0,RowNo()))

[rustyfishbones]

you can also use

to get the running Average

hope that helps

[aveeeeeee7en]

Thanks Alan, it is working Perfectly.

But I have used it earlier. As I said in my requirement, I need this thing from the Script not from my Chart Expression.

[maxgro]

a:

load

  MOB,

  alt(peek(MOBSUM),0) +MOB as MOBSUM;

load * inline [

MOB        

10         

20         

30         

40         

50    

];

EDIT

or this?

a:

load

  MOB,

  alt(peek(MOBSUM),0) +MOB as MOBSUM,

  if(rowno()=1, text(MOB), peek(MOBSUMTXT) & ' + ' & text(MOB)) as MOBSUMTXT;

load * inline [

MOB         

10          

20          

30          

40          

50     

];