Jump to content

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.

Thanks in advance!

Link to comment
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).]

Link to comment
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!

Link to comment
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 tongue.gifhase=InvoiceChecklistDetails: tongue.gifhase)

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!

Link to comment
Share on other sites

This topic is 8504 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.