Survey123- last non empty field

74
1
04-03-2018 02:24 AM
GregorSenegacnik
New Contributor

Hi!

One question. I created cascading select (with 6 levels) and now I want create another field where app will automatic calucalted the last non - empty field (from 6 levels of cascading select) because all variable do not have all 6 levels.

I tried with "coalesce" but unsuscsefully.

In excel this can be solve with index or lookup like here: excel - Last non-empty cell in a column - Stack Overflow 

Result should look something like this:

 vari_1     vari_2    vari_3    vari_4      vari_5       vari_6          last_non_empty 

sdf           sdf         dsf          dsf           sdf                                   sdf 

r               ret          ert                                                                  ert  

5rt            ztr          rtz           rtz            r                   gdf              gdf   

Reply
0 Kudos
1 Reply
GregorSenegacnik
New Contributor

I found solution, i used IF nested functions. 

Reply
0 Kudos