Forum Discussion

JasonBowen's avatar
JasonBowen
Qrew Trainee
7 years ago

Totaling a field with matching criteria from an UNRELATED table

Background: An [EMPLOYEE] can have many [OVERTIME] records (which are added by a supervisor after the overtime has been accrued). An [EMPLOYEE] can have many [OT PROJECTION] records (which are p...
Tables and fields
AmberPolston's avatar
AmberPolston
Qrew Cadet
6 years ago
Is there a way to achieve these same results without the need for an actual relationship? 

I created report links to show the data I needed to report; however, I need to know the total $ shown on each of the report links.  I didn't initially build it with a relationship because it wasn't needed, but now, I need those summary fields and I can't find a formula for a summary field without doing a relationship.



------------------------------
Amber Polston
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You will need to have a relationship.  You will be able to able to have the reference field be calculated via a formula field, but the issue will be if your formula involved lookup fields, as they will prevent you from creating summary fields on that Relationship.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------