Power Query Custom Column Question

[jeancake]

I have a file that contains transactions that are broken down into credits and debits. The issue I have is that the debits are not presented as negative numbers. I tried to create a custom column that stated if the transaction type = Debit than multiply it by -1 else keep the original amount, but it didn't work.

1) The custom column was formatted as text.
2) When I transform the column to decimal it still doesn't apply the formula.

I'm pretty new to Power Query and I figured that the approach I used would work.

What's the correct approach?

Thank You!

 

[MarcelBeug]

The approach sounds correct. The formula for the custom column should be like:

if [Type] = "Debit" then [Amount] * -1 else [Amount]

If it doesn't work in your case, then you need to provide more details for us to understand what is going wrong.

 

[jeancake]

I took a look at the raw data and saw that there were some errors that forced the data type to text which is why the formula didn't work. I fixed the error and it worked fine.

Thanks for your help.