Forecasted revenue based on timeline

Platform discussions
, ,
1

Hi,

I am wondering whether it is possible to forecast revenue based on the timeline. Please see attached picture:
image
image

Let’s say that we have contracted value of 100K but we have only worked with it since 1st April and today it is 1st of May (1/5 of total project time), can we show forecasted value as 100*(Timeline) in some way?

Br
Gustav

2

@gustav.jacobsson

Yes.

100 * DAYS(TODAY(),{Timeline#Start}) / DAYS({Timeline#End}, {Timeline#Start})

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man

3

Thank you so much ! :slight_smile:

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.