Calculating fields

[freecolours]

Who can please help me with this?

I want to calculate, in a timecode database, the total of working hours in a portal, compared (looked up) from 2 fields. (for example: if field "ordercode" value =8001 and if field "ordernumber"=2002-01, then add up fields "working hours".

I hope I've explaned this clearly enough?

[danjacoby]

You can get the total of a field in a portal by creating a calc field:

Sum(Relationship::RelatedField)

Just put the calc field on a layout somewhere (not in the portal!).

As far as the "2 fields" stuff goes, no it's not clear, but I think the answer is to make sure that the particular relationship and related field already compares the 2 fields to make sure that it only returns the working hours if you want them included in the total.

BTW, you don't even need a portal; the calc field will work anyway.