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.