Cricket innings chart

[Anonymous]

Hi, I have attached cricket innings document. I am not able to calculate the cumulative score. I used the following expression : RangeSum(Above(sum(Runs),0,RowNo())). Can anyone tell me how to calculate run rate and rate/5 over.

[Anonymous]

Your Expression is correct....

Is there any error/ issue that your are notable to get desired results........

[anbu1984]

Can you attach sample app

[MK_QSL]

Load Below script...

LOAD Over,

     F2,

     SubField(Score,'/',1) as RunsPerOver,

     Score,

     Runs,

     [Run Rate],

     [Rate/5ov],

     F7,

     Score1,

     Runs1,

     [Run Rate1],

     [Rate/5ov1],

     [Rate Req],

     [Runs Req],

     [Balls Rem]

FROM

[http://www.espncricinfo.com/england-v-india-2014/engine/match/667727.html?view=comparison]

(html, codepage is 1252, embedded labels, table is @53, filters(

Remove(Row, Pos(Top, 1))

));

==============

Create a straight Table

Dimension

Over

Expression

For RunRate

RangeSum(Above(SUM(Runs),0,RowNo()))/Over

For RunRate of Last 5 overs

IF(RowNo() < 5, Null(), RangeSum(Above(SUM(Runs),0,5))/5)

UPDATE:

Or you can use below expression also...

For RunRate

RangeSum(Above(SUM({1}Runs),0,RowNo()))/Over

For RunRate of Last 5 overs

IF(RowNo() < 5, Null(), RangeSum(Above(SUM({1}Runs),0,5))/5)

[MK_QSL]

Like this?