Tables show only when the Year is different from 2013

[#1]

Hey guys,

Nowadays I have this statement for a table to make it appear (Show conditional in Layout):

GetSelectedCount(Year) + GetSelectedCount(Situation) + GetSelectedCount(Region)+ GetSelectedCount(Type)

+ GetSelectedCount([Airport Code])+ GetSelectedCount([Phenom 100])+ GetSelectedCount([Phenom 300])

+ GetSelectedCount([Legacy 600])+ GetSelectedCount([Legacy 650])+ GetSelectedCount([Lineage 1000])

+ GetSelectedCount([Publish/Draft]) >0

Now I would like to add to these statement that if the Year is 2013, this should not appear. How can I add this???

[Anonymous]

Julio,

If you have always Year selected, add this after ">0":
and Year<>2013
If multiple years can be selected, and you want to hide if 2013 is in selection, add this:
and match(GetFieldSelections(Year),2013)=0

Regards,
Michael

[CELAMBARASAN]

GetSelectedCount(Year) + GetSelectedCount(Situation) + GetSelectedCount(Region)+ GetSelectedCount(Type)

+ GetSelectedCount([Airport Code])+ GetSelectedCount([Phenom 100])+ GetSelectedCount([Phenom 300])

+ GetSelectedCount([Legacy 600])+ GetSelectedCount([Legacy 650])+ GetSelectedCount([Lineage 1000])

+ GetSelectedCount([Publish/Draft]) >0

AND Year <> 2013

[MayilVahanan · Accepted solution]

HI

Try like this too

GetSelectedCount(Year) + GetSelectedCount(Situation) + GetSelectedCount(Region)+ GetSelectedCount(Type)

+ GetSelectedCount([Airport Code])+ GetSelectedCount([Phenom 100])+ GetSelectedCount([Phenom 300])

+ GetSelectedCount([Legacy 600])+ GetSelectedCount([Legacy 650])+ GetSelectedCount([Lineage 1000])

+ GetSelectedCount([Publish/Draft]) >0

AND not match(Year, 2013)