Joe Fab Posted March 30, 2006 Share Posted March 30, 2006 Hello, How do I get a portal calculation to work. I need to get a sum from a field in a portal and place that number in a field outside of the portal. Any help would be great. Thanks Link to comment Share on other sites More sharing options...
Genx Posted March 30, 2006 Share Posted March 30, 2006 Your calculation field needs to be in your parent table (where your portal TO is your related child table), and the calculation itself would just be: Sum(RelatedTable::RelatedField) ~Genx Link to comment Share on other sites More sharing options...
Joe Fab Posted March 30, 2006 Author Share Posted March 30, 2006 (edited) How do you calculate multiple lines? Your solution only works for the 1st portal line. attached is my working file. any help would be great. What I am trying to do is take the payments applied to the job and subtract the payments from the estimate. Thanks JobTracking.fp7.zip Edited March 30, 2006 by Guest Link to comment Share on other sites More sharing options...
Genx Posted March 31, 2006 Share Posted March 31, 2006 ...Didn't i say put it in the parent table? Have a look at the attached file and note the location of the field cBalance. ~Genx JobTracking_.zip Link to comment Share on other sites More sharing options...
Joe Fab Posted March 31, 2006 Author Share Posted March 31, 2006 Thanks I am still learning Link to comment Share on other sites More sharing options...
Genx Posted March 31, 2006 Share Posted March 31, 2006 No problems... Link to comment Share on other sites More sharing options...
Genx Posted March 31, 2006 Share Posted March 31, 2006 I can't believe i just did that... No problem, hehehe, i almost sound like a bogan . Link to comment Share on other sites More sharing options...
Søren Dyhr Posted March 31, 2006 Share Posted March 31, 2006 I'm learning as well... http://en.wikipedia.org/wiki/Bogan Is it Crocodile Dundee who have worn out "no worries" or??? ...Didn't i say put it in the parent table? However, if you're going to put such a calc' in more than one related table, could this add considerably to the muddle: http://www.fmforums.com/forum/showpost.php?post/159548/ ...it's not the first time I encounter later arrivals being confused with these matters - so putting extra matters into a pour minds ongoing struggle with concepts is evil, to some extend. --sd Link to comment Share on other sites More sharing options...
Genx Posted April 2, 2006 Share Posted April 2, 2006 Wikipedia cracks me up... hehehe, no, no worries is good, it seems to be more of a kiwi (new zealand) thing though. Then again so is "cheers". Oh well. ~Genx Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6741 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