Display a negative number as positive

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

2 Likes

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.

  1. Format as… provides the option to show negatives in (). However in my usecase, I want to remove the sign entirely.

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

1 Like

yup. brain fart.

1 Like

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.