Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoNo, those displayed totals or averages are not accessible by formula. But you can make a Parent table called Average Returns with a single record in it. It will be Record ID# of 1.
Then make a relationship to your Transactions table where 1 Average Returns has many Transactions. For the reference field on the right side, use a formula numeric field with a formula of
1
Then make any summary fields you like and do your calculations up there on the Average Returns record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then make a relationship to your Transactions table where 1 Average Returns has many Transactions. For the reference field on the right side, use a formula numeric field with a formula of
1
Then make any summary fields you like and do your calculations up there on the Average Returns record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------