Could you please attach sample data (packaged workbook = **.twbx is alwasys the best).
The solution is completely different according to on the data you have.
1 of 1 people found this helpful
here are a couple of ways
this will create a running total of the value and divide by the count
this is a table calculation that will thak an average over a fixed period (if you know the period - I used 6 in teh example)
either would return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.