Filter strings in a formula

[#1]

Good morning,

I am new to QV and need some help with filterring strings in a formula:

Given is the data in the following table: TB01_20140902_101356.xls

which shows the turnover and qty. per material and product hierache.

I would like to sum the turnover with the following formulas:

1. if (Produkthierarchie = 'X?*' , 'Y?*',sum(Nettoumsatz))

2. if (Produkthierarchie like 'GATE*' , 'ACTR*',sum(Nettoumsatz))

but both deliver the same result? Could you please help me resolving this?

Thanks, Matthias

[#2]

Thanks, unfortunately this is not the solution,

The best till now was:

1. sum({<Produkthierarchie ={ 'X?*' , 'Y?*'}>}Nettoumsatz)

2. sum({<Produkthierarchie ={ 'GATE*' , 'ACTR*'}>}Nettoumsatz)

I need to find out why there is the difference in the total summary of both results.

[jagan]

Hi,

I didn't get what you are expecting, can you come up with an example and expected value.

Regards,

Jagan.

[#4 · Accepted solution]

Hi Jagan,

first of all thanks for your help.

What do I expect:

the total turnover for the month of July for example was:

The field "Teile" is calculatet by

sum ({<Produkthierarchie ={ 'X?*' , 'Y?*'}>}Nettoumsatz)

"Anlagen" by

sum ({<Produkthierarchie ={ 'GATE*' , 'ACTR*'}>}Nettoumsatz)

"Nettoumsatz" by

sum (Nettoumsatz)

Since all Materials have a prod. hierach. which is either

X

Y    Y

GATE*

ACTR*

the sum of 

X

Y    Y

and

GATE*

ACTR*

should be

sum (Nettoumsatz)

but it is not, see table.

[jagan]

Hi,

I checked your excel with below expressions,

=sum ({<PH ={ 'X*' , 'Y*'}>}Nettoumsatz) + sum ({<PH ={ 'GATE*' , 'ACTR*'}>}Nettoumsatz)

and

=sum (Nettoumsatz)

both expression values are matching.

Regards,

Jagan.

[#6]

Hi Jagan,

had the wrong field, thanks for your help.

Matthias