AnsweredAssumed Answered

Sum up values in a table into a portal object

Question asked by firebase on Aug 24, 2018
Latest reply on Aug 24, 2018 by philmodjunk

I have a table where I have values like

 

SKU     Item     StockA     StockB

123     abc          1               2

123     abc          2               2

234     xyz          1               1

 

And the result in a portal object should be

SKU     Item     StockA     StockB     Sum

123          abc     3              4               7

234          xyz     1               1              2

 

I could do this eith SQl but is there any other way?

Outcomes