AnsweredAssumed Answered

Looking for direct calculations on a Found Set?

Question asked by googull on Nov 2, 2018
Latest reply on Nov 2, 2018 by googull

Placing a found set Portal on the same layout form is a welcome feature in v17.  I'd like to figure out a direct method to place a calculated field on the layout to summarize data that is contained in the same found set without having to script a loop.  For example, might there be a function or SQL command I could use to sum a column in the found set?  Similar to Get(FoundCount).  I'd like to insert an SQL or direct calculation where the scope to operate  on is Get(FoundSet) -  something like SELECT SUM ( a.\"Total\" ) FROM \"GET(FOUNDSET)\" a "... or WHERE latches to the found set.

Outcomes