FORMULA TOTAL A SPECIFIC FIELD
Hi,
I have a "calc sheet" table where all of the calculations are done for our royalty interest.
I need a way to take the Asset NMA for the acquisition and total it.
So for APU001 ACQ GROUP, t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnot a stupid question :)
Right today, the only way to get that total would be to have a Parent table of the ACQ groups, and then make a relationship to these detail records to get the Total, and then lookup that Total back down to the detail records.
But there is an early limited Beta feature out there now called Formula Queries which is new functionality to be able to do what you want, that being to grab totals without having a relationship. Access to that Beta is on request and by invitation only as they are doing performance testing to make sure the apps still are "Quick".
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Right today, the only way to get that total would be to have a Parent table of the ACQ groups, and then make a relationship to these detail records to get the Total, and then lookup that Total back down to the detail records.
But there is an early limited Beta feature out there now called Formula Queries which is new functionality to be able to do what you want, that being to grab totals without having a relationship. Access to that Beta is on request and by invitation only as they are doing performance testing to make sure the apps still are "Quick".
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------