Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
I didn't get what you are expecting, can you come up with an example and expected value.
Regards,
Jagan.
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.
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.
Hi Jagan,
had the wrong field, thanks for your help.
Matthias