Hi,

can someone help me calculating an average stock in my dataview? I have a monthly stock information and I want to divide it by number of months <> 0. I tried with a refer to but I can not calculate with the sum. If I try to divide 'a' by 'b' board does not use the total sum, for example 4 (first row), board divides by 1:

Thank you!

regards

Hendrik Hellwig

Hi,

you can easily solve this, using nexel:

=AVERAGEEX( [@a;*;*;Range.Horizontal] )

Or maybe the "Yearly Moving Average" function might also be helpful

Regards

Björn