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:)
Solved! Go to 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
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.