Formula for exclusion characteristics

[rassanbekov]

Hello!

Could you please advice how to exclude characteristic from expression?

For example

Calculation
Header 1 Header 2 Header 3 Charateristic 1 10 10 Charateristic 2 50 60 Charateristic 3 20 40

As a result, I need to multiple Header 2 with Header 3, and in calculation need to exclude the characteristic 3

Waiting you comments,

Thanks!

[qlikview979]

Not understand,

Please share the sample output

[Anil_Babu_Samineni · Accepted solution]

Like this?

Sum({<[Header 1] -= {'Charateristic 3'}>} ([Header 2] * [Header 3]))

[rassanbekov]

I have already included example of the input data in the message.

In the formula sum(header 2 * header 3), I need to exclude from calculation "Characteristic 3" or "20 and 40" respectively.