Selecting the last (most right) value of a list (of several columns) that is not blank

[stuggijo]

Dear Community,

I am struggling with to following issue:

I would like to get the last value (that is not blank) of a list that is based on different columns.

What I have found is that it is possible to choose the first value of a list (but I need the last one, that is not blank). What I want to achieve is when f.e. [Krs_v_27_J] is blank, I want [Krs_v_26_J] to be selected.

I have tried it out. But it seems like I miss something…

In my impression the values are resortet when I substract the List("") of my manual List( [Krs_v_24_J], [Krs_v_25_J], [Krs_v_26_J], [Krs_v_27_J] ) ) so that the wrong value is shown (not the last one of the list that is not blank).
I have also tried with the Sort expression. But that sorts the values based on the content of the rows, when I understand it correctly…

What do I miss and do you have an idea on that?

**
Any(
Top(
(
List(
[Krs_v_24_J],
[Krs_v_25_J],
[Krs_v_26_J],
[Krs_v_27_J]
)
- list("")
),
1
)
)
**

Thank you very much!