Forum Discussion
JoseBaez
5 years agoQrew Trainee
Hi Dan,
Correct I do have Cost Center table. I'm also am doing the math in the record but it sums the individual variances on the summary which is not the result needed.
Question - is there a way to create a formula field that captures the totals shown at the bottom of a Report Link?
i.e. pull in the total 40.3 into a separate formula field? I'm thinking as a workaround have the math show in each record..I think this will be acceptable because the report consumer has to view each record individually anyway.
Correct I do have Cost Center table. I'm also am doing the math in the record but it sums the individual variances on the summary which is not the result needed.
Question - is there a way to create a formula field that captures the totals shown at the bottom of a Report Link?
i.e. pull in the total 40.3 into a separate formula field? I'm thinking as a workaround have the math show in each record..I think this will be acceptable because the report consumer has to view each record individually anyway.
- QuickBaseCoachD5 years agoQrew CaptainHi this is Mark.
I'm not understanding the question now.
If you have all your fields on a record, you can just do a simple formula to calculate the variance, right? - JoseBaez5 years agoQrew TraineeSorry..Mark.
The variance calc in the record is missing the Filled and Opened totals for the Cost Center. Keep in mind its a sum of multiple records for each cost center. In other words, each cost center has multiple records within it...I need the sum of Total FTE (Open) and (Filled)...if I can get this in the record I'd be in business...the variance calc would work. - QuickBaseCoachD5 years agoQrew CaptainIf you have a relationship between the Cost Centers and their detail records, then you can make summary fields to get those numbers (Totals or averages) up to the Cost Center record.
- JoseBaez5 years agoQrew Traineeindeed you can!! woohoo!
awesome bud..thank you! - QuickBaseCoachD5 years agoQrew CaptainSometimes the answers are easy. Glad to hear it�s working.