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