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!

PwrAppetite
Regular Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,237)