Get Daily Value from start and end date

[Omarwaleedazab]

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

[V-pazhen-msft]

@Omarwaleedazab 

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.

[Omarwaleedazab]

@V-pazhen-msft 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 

https://we.tl/t-WmREWsAdcH