bdarch Posted March 15, 2005 Author Posted March 15, 2005 Friends, can you help me obtain a running count of records under a subsummary? I've tried summary fields, the GetSummary function, &etc but no luck. Under each break of the subsummary I want to number records starting with "1" and on up to the number of records. Then start again with the next break. What am I missing?
bdarch Posted March 15, 2005 Posted March 15, 2005 Friends, can you help me obtain a running count of records under a subsummary? I've tried summary fields, the GetSummary function, &etc but no luck. Under each break of the subsummary I want to number records starting with "1" and on up to the number of records. Then start again with the next break. What am I missing?
bdarch Posted March 15, 2005 Author Posted March 15, 2005 Friends, can you help me obtain a running count of records under a subsummary? I've tried summary fields, the GetSummary function, &etc but no luck. Under each break of the subsummary I want to number records starting with "1" and on up to the number of records. Then start again with the next break. What am I missing?
-Queue- Posted March 15, 2005 Posted March 15, 2005 See here for one technique. Since you are using 5 and not 7, instead of the final Let calc, use GetSummary( Count, breakField ) * Case( Position( TotInvCountByNum, ".", 0, 1 ), TotInvCountByNum - Int(TotInvCountByNum), 1 )
-Queue- Posted March 15, 2005 Posted March 15, 2005 See here for one technique. Since you are using 5 and not 7, instead of the final Let calc, use GetSummary( Count, breakField ) * Case( Position( TotInvCountByNum, ".", 0, 1 ), TotInvCountByNum - Int(TotInvCountByNum), 1 )
-Queue- Posted March 15, 2005 Posted March 15, 2005 See here for one technique. Since you are using 5 and not 7, instead of the final Let calc, use GetSummary( Count, breakField ) * Case( Position( TotInvCountByNum, ".", 0, 1 ), TotInvCountByNum - Int(TotInvCountByNum), 1 )
bdarch Posted April 6, 2005 Author Posted April 6, 2005 oh dear... stupid me.... I forgot I posted this and just asked the same question again. Queue THANK YOU for your help.
Recommended Posts
This topic is 7172 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