TJ53 Posted December 10, 2005 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!
BobWeaver Posted December 14, 2005 Posted December 14, 2005 See this post: http://www.fmforums.com/forum/showtopic.php?tid/92703
TJ53 Posted December 14, 2005 Author Posted December 14, 2005 Thanks Bob, I also got the solution by using Get(RecordNumber).
Recommended Posts
This topic is 6918 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