4 weekly inputs = 1 monthly amount
I have weekly inputs on a table for 8 different fields. I need to be able to sum each field each month and use that in other formulas. This will be ongoing so I need the summation to be by month & ye...
Forum Discussion
The fields need to be summed based on the month. Each of these "summed" fields are used in calculations to create a stacked bar chart showing values month over month for a specific machine.
I have one table with machines
---fields are department, machine
one table with the fields that are calculated by month.
Fields include machine, month, year, and the several formula fields
ex total breakdown/minutes ran
total quality / minutes ran
stop/minutes ran
The three above fields added together to make another field
In total there are 24 formula fields based on the input fields.
A third table will have these weekly inputs.
These fields are date (week-ending), machine, and the input fields
Breakdown, stoppage, quality, setup, tool, minutes ran
------------------------------
Rhonda Parriet
------------------------------
I have one table with machines
---fields are department, machine
one table with the fields that are calculated by month.
Fields include machine, month, year, and the several formula fields
ex total breakdown/minutes ran
total quality / minutes ran
stop/minutes ran
The three above fields added together to make another field
In total there are 24 formula fields based on the input fields.
A third table will have these weekly inputs.
These fields are date (week-ending), machine, and the input fields
Breakdown, stoppage, quality, setup, tool, minutes ran
------------------------------
Rhonda Parriet
------------------------------
Rhonda,
So sticking with the proposed architecture, you will need to make separate reports based upon what period of time you want the data summarized over. I am also assuming you are going to do a report for each machine to keep it readable.
Some sample data
Here is Chart Detail
And then the result for the Press
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
So sticking with the proposed architecture, you will need to make separate reports based upon what period of time you want the data summarized over. I am also assuming you are going to do a report for each machine to keep it readable.
Some sample data
Here is Chart Detail
And then the result for the Press
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------