Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
Did you tried with fabs()
fabs(Sum({<TransactionCategory = {'Equities'}>} #TotalValue))
Hi Arne
When using fabs u need to turn value before sum()
Sum({<TransactionCategory = {'Equities'}>} fabs(#TotalValue) )
/Teis