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!
Solved! Go to Solution.
Put it inside the Text(Abs( and you will get the result you seek!
@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?
Put it inside the Text(Abs( and you will get the result you seek!
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
260 | |
252 | |
85 | |
37 | |
33 |
User | Count |
---|---|
342 | |
264 | |
125 | |
73 | |
46 |