Field with diferent formula

[SivadPT]

Hi, this is my problem, any help will be appreciated

I have an invoice with lines corresponding to products.

On the lines exists a field “results” that is calculated with an exclusive formula for each product.

Imagine:

Invoice A123 has:

Product 1 “Results”

Product 2 “Results”

Product 3 “Results”

The “Results” field for: Product 1 is calculated A + B

Product 2 is calculated (A + / D

Product 3 is calculated C + G

For Product 1 I will introduce (on a different layout) values for A and B

For Product 2 I will introduce values for A, B and D

For Product 3 I will introduce values for C, G

:

That’s all folks. Again any help would be very good.

[Raybaudi]

Hi

that seems not a problem...

Those calculations must be evaluated in the Products table, while the fields in the LineItems table must enter Lookup values.

[SivadPT]

Thank you raybaudi.

Can you specify a little bit more.

A small exemple would be very nice.

[Raybaudi]

Hi

try this one

for_SivadPT.zip

[SivadPT]

Thak you very much.