TJ53 Posted December 10, 2005 Share Posted December 10, 2005 Hi, I neeed to have a sum field that calculates the total of a numeric field for all the related records minus the value of first 5 portal rows. That is, if the portal looks as follows: PORTAL: row 1: value=2 row 2: 3 row 3: 5 row 4: 2 row 5: 4 row 6: 1 row 7: 8 I need a sum field that would give me "9" as a result (row 6 + row 7), disregarding whatever values are from portal row 5 to above ... any ideas? Thanks very much in advanced! Link to comment Share on other sites More sharing options...
BobWeaver Posted December 14, 2005 Share Posted December 14, 2005 See this post: http://www.fmforums.com/forum/showtopic.php?tid/92703 Link to comment Share on other sites More sharing options...
TJ53 Posted December 14, 2005 Author Share Posted December 14, 2005 Thanks Bob, I also got the solution by using Get(RecordNumber). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6699 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