Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Date formula help please

190 0
Showing results for 
Search instead for 
Did you mean: 

Hello the community,

my table has a list of projects (one line per project) with monthly income and a number of months, thus calculating the yearly income per project (one column for monthly amount and one column for number of months) and per year if i sum all the lines.

i am trying to create a view so I can visualize (in a dashboard) my forecasted revenue per month that includes all projects. The problem is that my table does not provide in which specific months the monthly revenue applies.

I also have a column with project start date and a column with project end date but I am not sure how i can use it to capture a monthly revenue per project.

i hope my explanation is clear enough.

Thank you in advance for your help!

0 Replies 0