Hi Team,
Need some quick analysis for the below data in averaging.Please suggest
Example:
I am running data for April month which should be average of above three months as shown below(Actually April data is not available...we have data till march).
Months | Value |
Jan | 2 |
Feb | 3 |
Mar | 4 |
April | 3 |
Now when I run data for May month(which is actually not there)...it should be average of above 4 Months as shown below(April data is now made available):
Months | Value |
Jan | 2 |
Feb | 3 |
Mar | 4 |
April | 6 |
May | 3.75 |
Similarly when I run data for June month,it should be simply average of above 5 months as shown(May data is now made available):
Months | Value |
Jan | 2 |
Feb | 3 |
Mar | 4 |
April | 6 |
May | 7 |
June | 4.4 |
Thanks in advance:)
Hi @Polite123
Here is a workflow for the task.
Input:
Output:
It is designed to take next month of the last month and value as avg of all previous months
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @atcodedog05,
Thanks.But this seems to work for only May month and not for other months.
I actually needed it to be a continuous process.
While running for April---The value for April should be average of Jan,Feb,Mar
While running for May---The value for May should be average of Jan,Feb,Mar,Apr.
Similarly for all months except for Jan every year which is a fresh month.
Can this be implemented in some way may be?
Thanks in advice
Hi @Polite123
It is built in a way that it will calculate next month based on the exiting data.
Output (case 1): Months till April so calculating May
Output (case 2): Months till May so calculating Jun
Workflow:
Please check and let me know
Hi @Polite123
For the scenario when next month is Jan its not added.
Input and will remain same and gives a warning.
Input:
Output: Input and output are same and it will give a warning (could be changes to error also.)
Hope this helps 🙂
Hi @atcodedog05 ,
Yes you are correct but the problem is I have a file which has all months included in them and for example while trying to calculate data for March month,the average is getting reflected in the highest month and not in March month because the workflow is built that way(you have added a formula)
Requirement:
I have list of all months mentioned in the file and the average must be calculated for the respective months.
Any help would be highly appreciated.Thanks:)
Hi @Polite123
Here is a workflow which calculates months value considering prev months average.
Input:
Output:
Make sure you have a column year so that Jan get reset each time as part of year start.
And there are few extra columns which will help you validate.
Workflow:
Hope this meets the requirement 🙂