Addition or subtraction of values in rows

[Anonymous]

Hello Experts,

i want to add and subtract the values received in load statement as shown in below table.

i have all data available in load statement except the calculated values marked in Yellow.

Please note that each value is received in a separate load statement and joined together. 

Is it possible to do this?

For your information the number of rows are fixed.

thanks in Advance

[sunny_talwar]

Do you have 'Total X+Y' and 'B-A' and 'T+G-Y' as a value within GROUP?

[Anonymous]

Not really 😞

I have X, Y separate as values  but not 'Total X +Y'... but i want the result in table like that.

All these values coming from a single QVD based on different conditions. Each with a separate load.

Each Group has a different condition.

[sunny_talwar]

Would you be able to share a small sample to show what you mean?

[Anonymous]

Hello Sunny,

Sorry, was not in office yesterday.

Please see attached example. I have written few load statements for example.

i have all load statements for all criteria carried out on same table. 

the expected result is like

Thanks

[Channa]

do with wildMatch

Concatenate below with your previous load

'X+Y',IF(wildMatch(Group,'X','Y'),SUm(Value)) resident Table

'A-B',IF(wildMatch(Group,'A',),SUm(Value))-IF(wildMatch(Group,'B',),SUm(Value))

[Anonymous]

Sorry, but it's not working... gives error as invalid expression

SUMX_Y:
LOAD
'X+Y' as SGroup,
IF(wildMatch(Desc,'X*','Y*'),SUM(Value),0) as StockValue

resident Master;

[Anonymous]

It needs a Group by for sum 😞

[Channa]

Table1:
LOAD
"Desc",
Value
FROM [lib://Source/Grouping.xlsx]
(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD
'X+Y' as Desc,
sum(Value) as Value Resident Table1 where WildMatch(Desc,'X','Y') ;

try

[Anonymous]

Thanks, it already works for sum but how do i manage subtraction for
B-A
T+G-H