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
Solved! Go to Solution.
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.
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
do with wildMatch
Concatenate below with your previous load
'X+Y',IF(wildMatch(Group,'X','Y'),SUm(Value)) resident Table
Sorry, but it's not working... gives error as invalid expression
'X+Y' as SGroup,
IF(wildMatch(Desc,'X*','Y*'),SUM(Value),0) as StockValue
(ooxml, embedded labels, table is Sheet1);
'X+Y' as Desc,
sum(Value) as Value Resident Table1 where WildMatch(Desc,'X','Y') ;