HunterBoss Posted November 28, 2010 Posted November 28, 2010 How do you find on a summary field? When I go to find mode, I can't enter the field. What am I missing? thanks Christopher
comment Posted November 28, 2010 Posted November 28, 2010 What would you expect to find? A summary field summarizes the current found set. The summary value does not belong to any specific record.
Søren Dyhr Posted November 30, 2010 Posted November 30, 2010 While this question admittedly is based on too many unsaid premises ... could we perhaps guess that the user are aware of the distinction between real summaries and aggregate functions. If so must the solution be provided with a GetSummary('-calc with a relevant breaker value for the search. This could supposedly be invoice lines belonging to a certain paid amount in a sort of FIFO arrangement, if the summary is the running kind. Say the scenario is a payment of $100 and the client/customer have a series of invoices unpaid. Here would a find not quite work ... but if you use the GetSummary( in a looping script will it work it's way towards where the running summary reaches the paid amount, provided the record is provided with a serial ID upon both the sorting and breaking is made. --sd
Recommended Posts
This topic is 5105 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now