calculation based on values from a portal

[serzone]

I hope I'm posting in the right place.

Here's the problem i'm trying to solve:

I have an Invoice table related to a SpecialPricing table (one to many relationship). In the invoice layout i have a portal that displays related records from SpecialPricing.

Bu here's the thing... I need a field "zField" in the Invoice table that gets a specific value depending on the records that show in that portal. something like this:

zField = if in the records displayed in the portal row you find item 1 or item 4 then put X if you don't find item 1 or item 4 then put Y.

Now maybe there's a simple solution to this but i can't figure it out... what i thought was: can i do a calculation field that "adds" (concatenates) all the items displayed in the portal and then to a patternFind on that concatenation field... but i don't know if i can concatenate that text... i know i can count the rows or sum numbers up but i can't concatenate text.

Ideas?

[serzone]

never mind... seems like i can concatenate that stuff in the portal using the List function:

List(SpecialPricing::Item Name)

and then i'll do the PatternCount() to see if the items exist in the portal...

Now the second problem is this: If the item is in the portal row (found by ItemName for example) how do i get the ItemPrice for that item?

[Anuviel]

Item price is in SpecialPricing table? It is my understanding that you should base the calculations in the SpecialPricing table and then display them in your invoice table.

Like a total for the order: in your invoice table you have a field that does Sum(SpecialPricing::ItemCost) and that would sum all of the related records in the SpecialPricing table and would display it in your invoice table.

Also what happens if you have Item 1 and Item 4 in the portal?