Hi Cog Nerds!,
Ppl I need help on understanding the following expression definition used in a Filter:
([Presentation Layer].[Survey].[Survey Region Code] in (?par_Srvy_Reg?) and (?par_static_8?) = '1' and (?par_static_6?) = '2')
To the best of my understanding the above definition implies:
if ( (?par_static_8?) = '1' and (?par_static_6?) = '2') )
then ([Presentation Layer].[Survey].[Survey Region Code] in (?par_Srvy_Reg?) )
Please help me confirm if my understanding is correct. Moreover I am unable to understand how with 3 and conditions an if and else is being implemented.
Any help would be appreciated.
Thanks in anticipation.
An if...else is not being implemented, not sure why you're saying both that you understand it is and don't understand why it is.
All three conditions in your example must be met for a record to qualify. If any of the three conditions is not met the record will not qualify.