Conditional Summing

[Gurratheboy]

Hi Guys, I'm stuck to say I wonder if it has with brain power to do...

 

Table "Pencils" fields:

----------------------------------------

State                                                                                                      Text | Has one of two values: "Activated" or "Deactivated"

Brand                                                                                                     Text |Can be one out of many brands......

Pricetag                                                                                                  Numerical |the price of each pencil

Sum_Pricetags_samebranded_and_activated pencils                           Calculation |?????

 

 

This is what I can't figure out for the last calculation field in the table "Pencils", How do I make a calculation out of the following:

In the calculation I want the Pencils from the same brand and with the same state "Activated" have their pricetags summed up and only if the two conditions are met.

 

Example:

2 pencils are of same brand and they are both in the state "Activated". The one pencil have a pricetag of 18£ and the second one have a pricetag of 10£

Because they are of same brand and both have the same state, I want their price to sum up, 18+10=28£ 

 

 

 It does not matter what the field say if the conditions are not met for other records, the field then can stay blank.

 

Cheers

[comment]

The simple way to do this is to produce a report. Start by finding the products that are activated, sort them by brand, and use a summary field (placed in a sub-summary by brand part) to total the price.