Hi all,
I'm just doing some work on my own bank statements imported from CSV. Two salient columns, MoneyIn (int), MoneyOut (Int).
This is the formula I'm trying to calculate:
((Revenue  Outgoings) * .81)  Dividends Paid = Result
I've been able to
Select
(Select Sum ([Money In]) As 'Revenue'
from SmytheData.dbo.Transactions3)

(Select Sum ([ Money Out]) As 'Outgoings'
from SmytheData.dbo.Transactions3
Where Reference not like '%Div%')
However, I need to multiply the result by 0.81 (to allow for 19% tax), THEN subtract
(Select Sum ([ Money Out]) As 'Outgoings'
from SmytheData.dbo.Transactions3
Where Reference like '%Div%')
TIA