PQ - Table replace values

[sandy666]

FundReturnTargetFundReturnTarget

a2%(3%)a
0.02
-0.03

b(3%)(10.3%)b
-0.03
-0.103

c(1%)(1%)c
-0.01
-0.01



// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Replace = Table.ReplaceValue(Source,"", "",(c,o,n)=> Number.From(Text.Remove(Text.Replace(c,"(","-"),")")),{"Return","Target"} )
in
Replace