choose the first non-null value

[ali_hijazi]

Hello

I got three variables

v1, v2, and v3

i want to use these inside an expression but as follows:

if($(v1) is not null null then $(v1)

if($(v1) is null then if $(v2) is null then $(v3) else $(v2)

is there a way or a function that chooses the first non null value ?

the priority is for V1, then V2 and finally V3

[Anil_Babu_Samineni]

May be this?

1) If($(v1) <> '0' or $(v1) <> ' ' or $(v1) <> '-', $(v1))

2) If(IsNull($(v1)), If(IsNull($(v2)), $(v3), $(v2)))

[antoniotiman]

Maybe

Alt(V1,V2,V3)

Regards,

Antonio

[Anonymous]

Hi,

Maybe this:

     If(not IsNull($(v1)), $(v1),

          if(IsNull($(v1)), if(IsNull($(v2)),$(v3),$(v2)

               )

          )