Hi there,
I have a Bank Statement Import file with Debits and Credits in separate column and '$' signs preceding these values. E.g:
I have created the Import Template and have applied a multiplier of -1 to the Debit entries to reverse the sign.
I have applied a Transformation rule using a Replace function to replace the $ sign with nothing.
This all works, except when I have a Debit entry, it gets overridden with "0.00" from the Credit column during import, because the cell contains that value rather than nothing.
So, I need to remove the $ sign and remove the 0.00 entries so they don't overwrite my debits. I tried adding a second transformation to replace 0.00 with blank, but it raises an error like this on import:
I don't really understand this error because the dollar sign should have already been removed.
Can someone please advise how I can replace both the leading $ sign and the 0.00 entries?
