Forum Discussion
Linear Spread Value between Start and Finish Dates
Good Day,
I have the following Columns in "Table 1"
1. Activity ID - Unique ID
2. Start Date
3. Finish Date
4. Duration (in Days)
5. Total Labour Units
6. Labour Units / Day: Calculated Column Based on "Total Labour Units" / "Duration"
I also have "Table 2" based on CALENDAR.
What i am trying to Acheive is a MATRIX TABLE (sample screenshot below):
1. Rows: Activity ID
2. Column: Dates per Day (but be able to DRILL up to Month & Year)
3. Values: Labour Units / Day
I am struggling with the "Values" Formula to allocate the value to each day between the START & FINISH dates.
5 Replies
- Ashish_Mathur
Super User
- hackfifi
Helper V
Thanks Ashish_Mathur - Looks Good! Just trying to understand your how your "Custom1" column/list works. But seems to work!
- Ashish_Mathur
Super User
You are welcome.
- Greg_Deckler
Community Champion
Can you post some sample data along with what you expect that sample data to show versus what you are getting?
- hackfifi
Helper V
Thanks Greg_Deckler for responding.
I had posted the sample data and expected result as a photo. I hope you can view it. Let me know.