Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
Why do you think that this is a Many to Many. Maybe you can explain more of your tables. It looks like
1 Project has Many Project Forecasts
1 Project forecasts has many project tasks? is that the setup?
In any case, you can have summary fields to summarize for example just forecasts for the previous month, or the 2nd previous month, so the total revenue does not need ot be the sum a of all the forecasts, just a filtered set of them.
1 Project has Many Project Forecasts
1 Project forecasts has many project tasks? is that the setup?
In any case, you can have summary fields to summarize for example just forecasts for the previous month, or the 2nd previous month, so the total revenue does not need ot be the sum a of all the forecasts, just a filtered set of them.