Changing Negative Numbers to Positive Numbers

When I import bank transactions to a new database, the debits come as negative numbers. How can I globally remove the negative sign?

With the debit field as the active field choose Field > Morph > Fill with Formula…

If the field is still a text field, use the formula

replace(«», "-", "")

If the field is a numeric field use the formula

abs(«»)
1 Like

The abs( function, used either during the import process, depending on how you are doing it, or with a formulafill after the import.

1 Like