# Totals in Portal

This topic is 8504 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I have a new problem.

I have two fields in a portal window (which points to an external related file)

Amount and Phase. I want to total all the rows in the portal window that correspond to the Phase.

For ex:

Amount Phase

10 A

20 B

5 A

The total for A should be 15, and for B, 20.

##### Share on other sites

In the external file, create a calculation field for each phase, called PhaseAmountA, PhaseAmountB, etc. The calculation:

(If Phase = A, Amount, 0) and another field for B, C, etc.

The set up a calculation field in the original file (the one with the portal)for each phase, called PhaseTotalA, PhaseTotalB, etc. The calculation:

(Sum(ExternalFile::PhaseA) and another field for B, C, etc.

That oughtta do her.

Paul

[This message has been edited by pspafford (edited February 02, 2001).]

##### Share on other sites

quote:

Originally posted by pspafford:

In the external file, create a calculation field for each phase, called PhaseAmountA, PhaseAmountB, etc. The calculation:

(If Phase = A, Amount, 0) and another field for B, C, etc.

The set up a calculation field in the original file (the one with the portal)for each phase, called PhaseTotalA, PhaseTotalB, etc. The calculation:

(Sum(ExternalFile::PhaseA) and another field for B, C, etc.

That oughtta do her.

Paul

[This message has been edited by pspafford (edited February 02, 2001).]

I understand this solution but my situation has a twist. Phases A,B,C can be applied for all/or any invoices. But on the invoice layout, I just want to add up Amount fields for Phase A, Phase B, Phase C ONLY for that Invoice. (So I have two criterias, the phase in the invoicedetails d/b and the invoice ID field in the invoice d/b.)

For ex: Invoice 100

Portal Row 1: 100, phase A

Portal Row 2: 130, phase A

Portal Row 3: 200, phase b

Total for phase A = 230, B=200 for invoice 100 (not A=830 because of other invoices!)

Invoice 101

Portal Row 1: 600, phase A

Portal Row 2: 200, phase b

Thanks!

##### Share on other sites

I'm not quite sure how you are doing this but you need to specify the repetitiono the field you are pasting into:

Paste[select,"Repeating Filed",3]

You do this when you specify the field in the script at the bottom of field the diaog box.

##### Share on other sites

I figured it out, only to come up with another problem.

What I did was: create a relationship (Projects:docketNo=Invoice::docketNo)

I created a value list that is related using that relationship to find Invoice No. relating to that project no. Easy!

Now I need to sum!

I have Phase, Amount as repetetive fields.

I have a PhaseTemp and Amount Temp and nonrepetitive fields to do some related SUM calculations. Sum(relationship 2::Amount Quoted)

where relationship 2 is InvoiceChecklistDetails (project hase=InvoiceChecklistDetails: hase)

I'm just using these temp fields as a mini calculator to sum the desired phase.

Main question is how do I copy these contents into the appropriate index of a repetitive field? It only copies to the first row of a repetitive field (amounttemp)

All I'm doing is cut & paste into a repetitive field!

Help!

##### Share on other sites

This topic is 8504 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,448 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,241 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,477 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,095 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,728 views
×
×
• Create New...