Help with Set Analysis

[#1]

Hi,

Need to get the ASSIGNMENT Values populated in a straight Table against a Dimension.The following conditions need to be applied:

1. Customer= 'NA' or 'Exception'

         AND

2. ASSIGNMENT=(starting from) 'C-' or 'c-'

        AND

3. num(Customer)= mid(ASSIGNMENT,3)

My Result : Which satisfies 1 & 2 conditions
Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'}>)}ASSIGNMENT)

Need Help in Adding the 3rd Condition to the above SA...

[alexandros17]

Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'}, Customer={'$(=mid(ASSIGNMENT,3))'}>)}ASSIGNMENT)

try this

[#3]

Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'},

Customer={'$(=mid(ASSIGNMENT,3))'}>)}ASSIGNMENT)