Multiple condition on expression

[viswamtulasi]

I would like to use the below conditions on expressions –

1. On search box file expression –  

Exclude few regions –

  =if ([Region] <> 'AP', 'EU', 'SA' ‘CA’, [Region])

1. On Chart expression –

Need the multiple conditions which includes AND and OR conditions

Sum({<
[Cycle] = {'YES'},
[Funding_Region] -= {'AP', 'EU', 'SA'},
[Skill_Team] -= {'BANK', 'Non Bank'},
[ICode] = {'*SBI*'} > +  < [ICode] -= {'*SBI*'}, [Product_Service] = {'Customer Value'}
>} [Budget])/1000000

Thanks in advance to support on the above expressions.

[sunny_talwar]

May be this

Sum({<[Cycle] = {'YES'}, [Funding_Region] -= {'AP', 'EU', 'SA'}, [Skill_Team] -= {'BANK', 'Non Bank'}, [ICode] = {'*SBI*'}, Region -= {'AP', 'EU', 'SA', 'CA'}> +  <[ICode] -= {'*SBI*'}, [Product_Service] = {'Customer Value'}, Region -= {'AP', 'EU', 'SA', 'CA'}>} [Budget])/1000000