Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to use the below conditions on expressions –
Exclude few regions –
=if ([Region] <> 'AP', 'EU', 'SA' ‘CA’, [Region])
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.
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