Calculate percentage of active days in Timeline

Platform discussions
, , , ,
1

Hi all

I want to calculate the monthly income of a client thats always the same, but based on the amount of days the contract was active that month.

For example. The Timeline is selected from the 8th of July until the 31st of July. The “normal” income is €1000. According to this calculation the “active value” should be around €770.

I’ve been trying for quite a while longer than I’d like to admit. Someone with an insight for me on how to calculate this?

Cheers, feel free to ask if something is unclear, my brains are fried.

2

hi @TomTtgt

We are currently developing an app that does do (kind of this). It takes a timeline and a value and calculates the value for this month and next month depending on what percentage of the timeline is within this and next month. Is this what you are looking for?

3

Hi Tom,

What about:

1000*DAYS({Timeline#End},{Timeline#Start})/30

 
 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday. - Create formulas without using the Formula column (and avoid its limitations) - Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board. - In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

4

Hi @basdebruin

I only need a percentage based on how long the timeline is active this month. The calculation of the percentage and the value of the income I was planning to do in another formula tab.

So basically just looking to pull a percentage from a timeline.

5

Thanks Gilles

Seems to work if I change 100 to 10.

Only problem now is the day difference in months, 30, 31, 28 for feb,… any suggestion on how to account for this?

6

To calculate the number of days in the month, you can use:

DAYS(ADD_DAYS(DATE(2024,MONTH({Timeline#End})+1,1),-1),DATE(2024,MONTH({Timeline#End}),1))

**What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.