How to enable condition on a filter ?

[claudialet]

 Here is my expression on a column filter . It is a variable based filter level and has level 1 and level 4. 

if($(vFilter)=1 and ForeignFlag=1 , EntityNumber &'-'& EntityName ,

if($(vFilter)=4 and EntityTypeFlag=1, EntityNumber &'-'&  EnterpriseName))

i need the 2 flags to display certain types of entities at different levels. Because it is only specified for those 2 types when there are other entity types the report does not display any data.

How do I rewrite the condition so it shows data whether matching entity data is there or not ?  If the entity types match show that data if not show data for other types of entities 

[lfetensini]

Missing "Else" ?

If(
 $(vFilter)=1 and ForeignFlag=1,
 EntityNumber &'-'& EntityName,
 
 If(
 $(vFilter)=4 and EntityTypeFlag=1,
 EntityNumber &'-'& EnterpriseName,

 EntityNumber &'-'& EntityName  // <<< ELSE
))

[Channa]

if($(vFilter)=1 and ForeignFlag=1 , EntityNumber &'-'& EntityName ,

if($(vFilter)=4 and EntityTypeFlag=1, EntityNumber &'-'&  EnterpriseName,'0'))

if you wan to show different data write your else 

[claudialet]

 Hi Channa,

So I have another conditional flag  :  StateFlag =0 

If ForeignFlag =1    show foreign values   or 

If StateFlag = 0   show  state values

How do I incorporate this into the expression with else statement ?

if($(vFilter)=1 and ForeignFlag=1 , EntityNumber &'-'& EntityName ,

if($(vFilter)=4 and EntityTypeFlag=1, EntityNumber &'-'&  EnterpriseName,))