Calculating fields in a portal

[Joe Fab]

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

[Genx]

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

[Joe Fab]

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

[Genx]

...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

[Joe Fab]

Thanks

I am still learning

[Genx]

No problems...

[Genx]

I can't believe i just did that... No problem, hehehe, i almost sound like a bogan .

[Søren Dyhr]

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

[Genx]

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