nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

13063_en-US

liliconcom

Cumulative and Rolling Formula being stopped by missing data

Hi,

Thanks for the support I had from you and I have had these formulas which help me a lot to understand the trend of data better, however the missing cell values stop the formula computing. Do you have any ideas to eliminate this problem?

CUMULATIVE AVERAGE;

If( Row() == 1,

:SCORE,

(:CUMULATIVE SCORE[Row() - 1] * (Row() - 1) + :SCORE) / Row()

)

ROLLING AVERAGE (for last seven days)

If( Row() > 6,

Mean( :SCORE[Index( Row() - 6, Row() )] )

)

Re: Cumulative and Rolling Formula being stopped by missing data

Take a look at this post on efficient moving average algorithm. I use the formula a lot.

Re: Efficient moving average algorithm

Comments

There are no comments yet