Forum Discussion

AndresArcila's avatar
Qrew Member
3 years ago

Retreive the last value based on Field number

Hello community.

I need some help to retrieve the last value keyed from an item and autofill the column IF the value is empty. the information are in the same table.


    id           | item    | cost
quote n-1  | item a | 100 

quote n-1  | item b | 50

quote n     | item a | 80
quote n     | item c | 20
quote n+1 | item a | last value (quote n)
quote n+1 |item b | last value (quote n-1)
quote n+1 |item c | last value (quote n).

Plan B is create a new column and show the last known value from that item.

Thank you.

Andres Arcila
No RepliesBe the first to reply