Forum Discussion
MarkShnier__You
Qrew Legend
I'm familiar with this issue.
My solution was to create a saved Table to table import to import the value of the Summary total into a scalar field where they were not equal. Then summarize the scalar field.
I then made a formula URL button to run the saved import as many times as I knew the possible depth of the nesting. The saved T2T imports run very quickly. So for example, to run a report, I made a button to run the import 5 times and land the user in a report with correct totals.
The premise is the due to the recursive nature, the summary total was only correct at the lowest level.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
ThomasHarwood
10 months agoQrew Member
Thanks Mark! This seems like a simple solution.
------------------------------
Thomas Harwood
------------------------------