Forum Discussion

hackfifi's avatar
hackfifi
Icon for Helper V rankHelper V
8 years ago
Solved

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Can you post some sample data along with what you expect that sample data to show versus what you are getting?

    • hackfifi's avatar
      hackfifi
      Icon for Helper V rankHelper 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.