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?
Thank you very much!