Simple Expression help!

[hopkinsc]

Hi, i have quite a simple expression that i am trying to get working.

I'm not sure how to write it. basically i need..

if [operative name] is null then use [Status Name]. if status name is null then use [Completed Name] otherwise use [operative name]

Can anyone help please?

[MayilVahanan]

hi

if(Len([OperativeName]) = 0 and Len(StatusName)>0, StatusName, If(Len([operative name]) = 0 and Len(StatusName) =0, CompletedName, Operativename))

But can you say your condition in details..

Hope it helps

[hopkinsc]

Hi, that didnt work. but would it be because of the 0's in the expression? there wouldnt be any 0's, it would just be blank..

[#4 · Accepted solution]

if([operative name] ='', if([status name] = '', [complete name], [status name]),operative name)

unless the names would say NULL in which case

if([operative name] =<null>, if([status name] = <null>, [complete name], [status name]),operative name)