Totals in Portal

[Jessica]

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.

Thanks in advance!

[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).]

[Jessica]

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!

[john.daly]

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.

[Jessica]

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!