Forum Discussion
Solved
Expression.Error: We cannot convert the value 1462962.3900000001 to type List.
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.
I believe I solved it by adding the Table name before the column. ie:
#"Table Name"[#"Column Name"]{[Index]-1}
1 Reply
I believe I solved it by adding the Table name before the column. ie:
#"Table Name"[#"Column Name"]{[Index]-1}