cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PwrAppetite
Regular Visitor

Remove Negative Symbol from calculated value label

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@PwrAppetite 

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

View solution in original post

4 REPLIES 4
Drrickryp
Super User
Super User

@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.

@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
Super User
Super User

@PwrAppetite 

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

View solution in original post

PwrAppetite
Regular Visitor

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,029)