Is there another way to not show the (-) sign to the user when a number is negative?
Iām not sure I understand your question correctly, but sure, there are multiple ways to remove the ā-ā.
For example, you could use the :find&replace expression. Or, you can create a conditional that says something like āwhen this number < 0, then take that number times -1ā
When you have a dynamic expression that is using a data type that is of type number you have access to an operator of :formatted as and can choose ānumberā and then there is a option to show negatives in ().
In terms of your post title
Display a negative number as positive
The above works well
Using a conditional on when result < 0 then multiplying by -1 is what Iām doing atm.
Find&Replace or the format option are both cleaning ways to go. Thx!
Tried replacing conditions with Find and replace or Format as and ran into these issues.
-
Format asā¦ provides the option to show negatives in (). However in my usecase, I want to remove the sign entirely.
-
there is no find & replace when the value is a number type.
Thereās nothing wrong with this method and you donāt have to make it conditional either just multiply the number by -1 period.
The condition is there so that if the result is positive, then multiplying by -1 will make it negative.
yup. brain fart.
So, you will use the format as operator to show negatives in the () and then use the find & replace operator to find and replace the () = Problem Solved.