Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There are several "OR" and "AND" condition in my set analysis. The below code is not providing the correct results. What am I missing? Any help you can provide is appreciated. Thanks!
CRITERIA:
Based on the current user selection count distinct CSN_ID's if the following condition is met:
Either HK7959 OR OFF_HK7959 has a value of 'Y'
AND
Either HK8017 OR OFF_HK8017 has a value of 'Y'
AND
Either HK8020 OR OFF_HK8020 has a value of 'Y'
AND
Either HK8024 OR OFF_HK8024 has a value of 'Y'
AND
Either HK8032 OR OFF_HK8032 has a value of 'Y'
AND
Either HIP2111 OR OFF_HIP2111 has a value of 'Y'
({$<HK7959={'Y'}>+<OFF_HK7959={'Y'}>*<HK8017={'Y'}>+<OFF_HK8017={'Y'}>*<HK8020={'Y'}>+<OFF_HK8020={'Y'}>*<HK8024={'Y'}>+<OFF_HK8024={'Y'}>*<HK8032={'Y'}>+<OFF_HK8032={'Y'}>*<HIP2111={'Y'}>+<OFF_HIP2111={'Y'}> }DISTINCT CSN_ID)
Silly question... have you considered creating this as calculated field in the load script ?
Use parentheses to group the union sets and give them precedence over the intersection sets, like in
...{(Set_A + Set_B) * (Set_C + Set_D) * (Set_E...}...
Best,
Peter
Thanks!