Calculation Problem

[abomb]

Hi all,

First off, question is pretty straight forward. It is probably answered in another post but I either didn't find it or couldn't really understand what was going on in the others to figure out a solution.

I am trying to sum a line from portal into a field. The item is "Total Weight." I found a formula in a post that I thought would work like this; "Sum(Portal_Relation::Payments), but it doesn't. Again, maybe I just don't understand it or how to make it into the results I want. If someone could please break it down step by step, as I am still new to FM7, I would really appreciate it.

Abomb

[RalphL]

Replace Portal_Relation::Payments with the name of the relationship and the field you want to sum.

Step by step:

File - Define - Database

Fields

Select table

Field Name: type Sum

Type: Calculation

click on Create

Scroll down the function list until you reach Sum (Right side of dialog box)

Double click on Sum

Selecte related table (Top left side of dialog box)

Find the field in box below table name

Double click on field name

Click OK button

Click OK button

Go to layout

enter layout mode

add the field sum

I hope I didn't overdo this

[abomb]

Got It. Thank you very much.