Average by time column

[johnnyjohn]

Gurus, 

I'm trying to calculate the cumulative average of the price by increasing time column per ID

Can you help with a formula to do this please? 

[chrismarlow]

Hi,

Because ParentID is your first column (so RowNo() restarts with each set) and assuming the sorting stays the same, I think it should be;

rangeavg(above(sum(Price),0,RowNo()))

Cheers,

Chris.

[johnnyjohn]

Thanks Chris, 

Doing that only seems to basically just copy the price column, it does not do any cumulative averaging 

[chrismarlow]

Hi,

Hmmm, curious. When I did a simple model it worked (see below), but agree when you add in another dimension it fails;

Cheers,

Chris.

[brunobertels]

Hi may be this 

rangeavg(above(sum(<Id,Time>Price),0,RowNo()))

[johnnyjohn]

Thanks, however that formula doesn't seem to work. It expression isnt getting parsed  (missing ')' )