Expression.Error: We cannot convert the value 1462962.3900000001 to type List.

[patri0t82]

Hello, I'm having a difficult time understanding why my custom column isn't working. It's basically just saying 

if.....      then [#"Column Name"] {[Index]} -1

I have an [Index] column starting at 0 and [Column Name] (containing decimal numbers). I just want to pull the previous row's decimal number if the current row shows a blank. There are no nulls in the table, they've all been replaced with 0s.

[patri0t82 · Accepted solution]

I believe I solved it by adding the Table name before the column. ie:

#"Table Name"[#"Column Name"]{[Index]-1}