Forum Discussion
Get Daily Value from start and end date
Hello
im trying to get Daily Values from start and end Date from the follwoing sheet sample
what im trying to to achive a table with each day of the month with totals tons accuired in each day
as the table below
| Month Days | Tons Per Day | Any KPI |
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
2 Replies
Anonymous
I am not very clear with this, could you provide a sample table that I can just copy and past. Meanwhile visually show your expect output to explain.With current information, I assume you want to show sum of tons for each day, but there are records across multiple days, so I doubt the requirement can be achieved. For example 3.60 days, you don't have any criteria to distinguish how many tons from each of the 4 days.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Anonymous thanks for your reply
i will attached to you a sample file of the data and the rquested report that i would liek to reach
and u will find all the fourmula used for tons per day and days calculations
will be waiting for your feedback