Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
9 years ago

Summary field not working--suspect key and reference field issue

I have tables for Project Forecasts and Project Tasks (which include revenue). Each of these tables has a field, Project Number.  On each Project Forecast, I want to summarize the revenue for a given ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
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.