Remove Negative Symbol from calculated value label

[PwrAppetite]

Hi All - 

I have a list with negative numbers (in the list with parentheses). I am trying to display the number without the "-" negative symbol being displayed from my calculated value. Here is my formula...

LblSum > Text Property is set to the following...

Text(Sum(Filter(colBottom,Types.Value="negative"),Amount), "[$-en-US]$#.00")

collection (colBottom) with one column "Types" and another column "Amount" 

Calculated to sum the "Amount" of "Types" with a value = "negative"

This is the number format that I get: -$34,400.00

What I would like to get: $34,400.00

What would be a close second: ($34,400.00)

Any ideas would be appreciated!

[Drrickryp]

@PwrAppetite Multiply it by -1 if it is less than 0. You could also square it and then take its square root or wrap the formula in Abs(). I was just kidding about the first two.

[PwrAppetite]

@Drrickryp  I was excited to see a short reply making it seem simple, until I read those first two options 😥 Abs worked to remove the - symbol, but it also removed my currency format. I could add in the $ but is there a way to retain the commas in the format as well... $34,400.00?

[Drrickryp · Accepted solution]

@PwrAppetite 

Put it inside the Text(Abs( and you will get the result you seek!

[PwrAppetite]

Boss! thank you @Drrickryp  that did the trick!!