Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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') ;
Check attached