i have an estimate_line_items and i have put some fields( product id,
product name, product_unit etc).My products tab includes both
services and products but the services are considered as products
( there is a category that separates the material-products from the
services).
What i am trying to do is to calculate the sum from the product_unit
field from the estimate_line_items( portal) EXCLUDING the number of
services which is also appeared on the field. Thus, i want the sum
that will appeared to give me only the sum of the material-products
and not the services!

i am fucking confused and i cannot find a solution...
any ideas????????

"vaggelis" <pantidos (AT) gmail (DOT) com> wrote

Create a new Calculation Field, in same Table as the product_unit Field,
which uses an If statement to distinguish between a "service" and a
"material".
e.g. something like:
material_unit Calculation, Number Result, Unstored
= If (product="service"; 0 ; product_unit)

Then you can use this Field to sum the portal records instead of the
product_unit Field.
i.e.
sum_portal_material Calculation, Number Result, Unstored
= Sum(Relationship::material_unit)


Helpfull Harry )