Percentage Calc

[Slobey]

Hi,

I have a solution that has a table called Descriptors and a line item table for it with a portal. The line items are taken from a part table. I have a part called "Miscellaneous materials". I want the price to be 3 percent of the total price of the "Descriptor". I made a calculated field in the Descriptors line item table as follows: (note: p 002072 is the part ID for miscellaneous materials.

If(Part ID="P 002072";

Descriptors::Descriptor Cost * .03;

Parts ID::Unit Cost)

It is a an auto enter calculation, replacing existing value.

The main problem I have is that it finds 3% of the total with the Miscellaneous materials added before calculating. I need it to find the 3% of all other items before adding it in. Does this make sense and how can it be done.

Thanks