To calculate average in the same column

[Polite123]

Hi Team,

Please help me with the below issue

I run the workflow everymonth and for example if I am running it for March month below is the input

Input:

March values are 0 when run for march month 

Points	Months	Values
A	January	25
A	February	5
A	March	0
B	January	20
B	February	6
B	March	0
C	January	8
C	February	5
C	March	0
D	January	10
D	February	2
D	March	0

Output:

For point A

March=(Jan+ Feb)/2=15

Similarly for point B,C,D

Points	Months	Values
A	January	25
A	February	5
A	March	15
B	January	20
B	February	6
B	March	13
C	January	8
C	February	5
C	March	6.5
D	January	10
D	February	2
D	March	6

When we run for April month,March values get updated and April values for point A should be average of Jan,Feb,March/3

example:

March data got updated and April month is now average of Jan Feb Mar

April=(Jan+Feb+Mar)/3=10.66 for point A

Similarly for B,C,D

Similarly I want to do this for all months when data gets updated every month

Points	Months	Values
A	January	25
A	February	5
A	March	2
A	April	10.66667

Any quick help will be highly appreciated.

Thanks in advance:)

[L_T]

Hi, 

would the attached workflow work?

[KarolinaRoza · Accepted solution]

Hi @Polite123 ,

If I understood your problem correctly, every month after running the (first?) workflow you have new month added but with the values 0, right?

If yes, I used that information as starting point to exclude last month with 0 values, and calculate average.

Please let me know if it works for you.

Karolina

[mceleavey]

Hi @Polite123 ,

I've attached the workflow for you.

This is simply using the running total tool and dividing by the record ID -1.

M.