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

[Anonymous]

Hello,

i managed it to do using a variable as below.

but i was wondering if i can avoid one more resident load and instead hust load 2 values from 2 variables in load statement like . It doesn't give any error but no values in the table.

SUMB1:
LOAD
'B-A' as SGroup,
($(vB) - $(vA))as StockValue;

[Channa]

can you try preceding load

like

Load
'A-B' as Desc,(ValueB-ValueA) as Value ;

LOAD
IF(Desc='B', Value) as ValueB ,
IF(Desc='A', Value) as ValueA
FROM [lib://Source/Grouping.xlsx]
(ooxml, embedded labels, table is Sheet1) where WildMatch(Desc,'B','A') ;

[sunny_talwar · Accepted solution]

Check attached

[Anonymous · Accepted solution]

Thanks Genius 🙂