Sum(field) BUT how can i exclude a part of the field?...

Main Page | Report this Page

Computers Forum Index » Computer - Databases - Filemaker » Sum(field) BUT how can i exclude a part of the field?...

Page 1 of 1

Sum(field) BUT how can i exclude a part of the field?...

Author

Message

vaggelis...

Posted: Fri Oct 16, 2009 7:35 pm

Guest

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... Sad

any ideas????????

Your Name...

Posted: Sat Oct 17, 2009 2:05 am

Guest

"vaggelis" <pantidos at (no spam) gmail.com> wrote in message
news:10c8ede8-967c-4e58-9391-11fc5f3a2dac at (no spam) k4g2000yqb.googlegroups.com...

Quote:

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 {BEEP} confused and i cannot find a solution... Sad

any ideas????????

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 Surprised

)

Page 1 of 1

All times are GMT The time now is Sat Nov 28, 2009 4:39 am Computers Forum Index