How to return negative numbers from sum of positive numbers

[claudialet]

Here us my expression . It is calculated as positive but I need to show them as negative in a bar chart. The money format is not working

Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}>} if(wildmatch(Line,'5a','5b','5c'), Amount))

Here is my number format :

Money    $#,##0;($#,##0)

[sunny_talwar · Accepted solution]

What if you do this

-Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}, Line = {'5a', '5b', '5c'}>} Amount)