Not enough info but something like: SELECT SUM(OLD -NEW) as balance FROM some_table WHERE need_to_calc IS true order by balance; (or order by whatever column. Not sure balance is what you are trying to sort by.)
Bob S > On Mar 29, 2020, at 11:54 AM, doc hawk via use-livecode > <use-livecode@lists.runrev.com> wrote: > > I haven’t fully followed the queries that led to this, but would something > like > > SELECT SUM(OLD -NEW) FROM some_table WHERE need_to_calc IS true; > > get you anywhere? > > > I’m also thinking of a lag within the list, to assign them all at once, but > the commands coming to memory are from statistical packages, Fortran, > spreadsheets, and other matrix math . . . > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
