Expression in Title

[#1]

I have th folowing expression in title:

='Asia Pacific (' & if( GetFieldSelections([Demise Year])='','All Years',GetFieldSelections([Demise Year])) &')'

When Demise Year is selected (2011 for instance) I am having Asia Pacific (2011) which is correct. When i clear all selection I expect to see

Asia Pacific(All Year) but I only have Asia Pacific()

Any help will be appreciated. Thanks

[erichshiino · Accepted solution]

Try to make it like this:

='Asia Pacific (' & if( len(trim( GetFieldSelections([Demise Year]) ))=0,'All Years',GetFieldSelections([Demise Year])) &')'

maybe the result is not blank in this case, but a NULL which is different from blank (NULL <> NULL too)

Regards,

Erich

[#3]

Thanks a lot Erich