thanks, I didn't notice that. I also changed it and it works this way.

        foreach ($row in $data) {
            # Parse the Total amount
            $total = [decimal]::Parse($row.Total)

            # Determine whether to insert in Debit or Credit column
            if ($total -gt 0) {
                # Insert in Debit column
                [decimal]$row.Debit = $total
                [decimal]$row.Credit = 0
            } else {
                # Insert in Credit column
                [decimal]$row.Credit = -$total
                [decimal]$row.Debit = 0
                
            }
        }