Hi,
I have the following table and I have to create a calculated field that calculates the average of the last 3 versions. For example, In v9 should show the average of v8, v7, &v9; in v8 should show the average of v7, v6, &v8 and so on... How can I achieve this? Please, find attached the workbook. Thank you so much!
2 risposte
good afternoon
you can try this
if LAST()=0 then
WINDOW_AVG (sum([Story points]),-2,0 ) end
see the red tab
