2 Replies Latest reply: Nov 11, 2016 8:05 AM by Teis thrane Wamsler RSS

    absolute sum of positive and negative values in table

    Arne Kanters

      Hi

       

      I have under #totalvalue the amountXprice, but this is negative for BUY and POSITIVE for sell

       

      How can I formulate the TOTAL of #totalvalue in absolute terms (not adding the plus and minus from buy/sell)??


      The below formula yiels the wrong result since it adds the buy and sell totalvalue, not the absolute numbers.

       

      Sum({<TransactionCategory = {'Equities'}>} #TotalValue)

       

      qliks1.JPG

       

      qliks2.JPG